data type was changed when exporting report from access to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access report that I exported to Excel. One of the columns has a
data type of "text". After it was exported in Excel, we noticed that some of
the values were changed. The values that contain all numerals and the ones
that start with zero have been transformed into something else. I tried
re-formatting the cells in Excel as "special" or "custom" or "general". But
all were unsuccessful. Can anyone help? - racky
 
I'm not sure why it does that, but you *might* be able to get around it by
adding an apostrophe to that text data before it gets exported.
eg. Go to the query (or create a query based on the table that is being
exported) and change the text field to read:

NewTextField: Chr$(39) & [OriginalTextField]

Regards,
Peter Hill
 
I'm not sure why it does that, but you *might* be able to get around it by
adding an apostrophe to that text data before it gets exported.
eg. Go to the query (or create a query based on the table that is being
exported) and change the text field to read:

NewTextField: Chr$(39) & [OriginalTextField]

Regards,
Peter Hill
 
Back
Top