Exporting to .CSV Files

[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?

 

[Ken Snell]

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.