Exporting to Excel changes data type (1 Viewer)

[hobbes]

Hi,

When I export a report to Excel it changes the data type of the column. For example, if I have a field in Access set to Text, but its data contains several fields with just numbers and other fields with a combination of numbers and text, Excel changes the format to Number. This problem will also eliminate the zeros from the beginning of a number string (which is an account number and needs to have the zeros) and changes other values in the column to scientific format. How do I keep Excel from changing the data type format once it's exported?

Thank you!

 

[BLeslie88]

common...

2 ways.

A - you can link the excel file to access, so formatting is kept.

B - simple way, add a small ' before you text ...

C - last way, you can run macros in excel to clean files as well...

 

[hobbes]

Is that for importing an Excel file to Access or exporting an Access report to an Excel file?

 

[hobbes]

I appreciate the help, but those options do not work for what I am trying to do. The information is being passed from Access to Excel. Any other ideas?

Thank you!
Hobbes