| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 78660 | 2007-04-24 01:28:00 | Access Quey Export to Excel | Alatel (12177) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 543708 | 2007-04-26 12:12:00 | Hi Alan I see what you mean. That is really bizarre. I've been using Access for eons but I have never seen that before. There are a couple of workarounds for this. The first involves using the exact method you described, but before you click the 'Export All' button, first tick the 'Save formatted' option. I'm using 2003 too and this seemed to fix the problem. An alternative method is to open the table in Access, select menu option Edit > Select All Records, the copy and paste into Excel - this method didn't have the funny values either. Just beware with this method the text alignment settings can be a bit wonky in Excel and it often converts the numbers into text. HTH, Andrew |
andrew93 (249) | ||
| 543709 | 2007-04-27 00:57:00 | Hi Andrew I will try your suggestions but would love a cure as I also use a Free programme called MDB Viewer Plus from www.alexnolan.net to view databases when at a PC without Access installed. (This is how I discovered the problem in the first place). It is a very handy programme if you do NOT have spaces in field names. (Spaced stop you sorting & filtering) |
Alatel (12177) | ||
| 1 2 | |||||