Exporting auto format

  • Thread starter Thread starter joey31
  • Start date Start date
J

joey31

I am exporting from Access to an Excel spreadsheet but I cant seem t
stop the auto conversion that takes place. When I open the Exce
spreadsheet the data is all different. E.g. I have a fund number o
"8E0" and the cell shows 8 and not the correct data. It's fustratin
for the datatype in Access is text and should stay the same in Excel
The version I have in Access and Excel is 2002 SP-2 Any Ideas how t
stop the auto conversion? I can do it by cut/paste of the query but
am trying to export via the report output itself to Excel. Thank
 
There is a similar problem importing to Access from Excel. I have
discovered that the column data format is set according to the first
item in the first record. If this can be interpreted as numeric,
despite any other settings, the whole column is treated as numbers.

Try ensuring that the first record field contains an alphabetic
character.
 
Back
Top