J
joey31
I am exporting from Access to an Excel spreadsheet but I cant seem to
stop the auto conversion that takes place. When I open the Excel
spreadsheet the data is all different. E.g. I have a fund number of
"8E0" and the cell shows 8 and not the correct data. It's fustrating
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 to
stop the auto conversion? I can do it by cut/paste of the query but I
am trying to export via the report output itself to Excel. Thanks
stop the auto conversion that takes place. When I open the Excel
spreadsheet the data is all different. E.g. I have a fund number of
"8E0" and the cell shows 8 and not the correct data. It's fustrating
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 to
stop the auto conversion? I can do it by cut/paste of the query but I
am trying to export via the report output itself to Excel. Thanks