Exporting to .CSV Files

  • Thread starter Thread starter Darren R. Barnes
  • Start date Start date
D

Darren R. Barnes

I have a problem with Excel seeing some of my alpha
numberic values as scientific numbers after I export my
query. I was trying to find out how to make a
Specification Table and can't find anything in the Help
function of Access and I searched through the Knowledge
Base as well. Does anyone here know where I should begin?
 
Use a calculated field in place of the actual field in the query:

TextFieldName: Format([RealFieldName], "")

or

TextFieldName: Format([RealFieldName], "@")

This will export the field as a text string and not a number.
 
Back
Top