importing/exporting from access to excel

[Guest]

Hi all,

I need a CVS file with some data I have in an access query. To do that I'm
trying to import (in excel) and Export (in access), and everything goes right
except the fields where I have up to 255 characters. These (in excel) only
shows the first 255 characters.

How to resolve this problem? or better, How to create a CSV file from my
Access query?

Thank you all. Tom.

 

[Guest]

In Access, rtclick the Query Icon, choose Export from the shortcut menu, &
change the File Type at bottom of the dialog box to whatever you need. If
"Text File", the next dialog box provides options for format which vary
depending on whether you check the box for "Save Formatted".

HTH |:>)