Help with export to excel

G

Guest

I am working in Access 97. I am trying to export 4 fields to excel. How can I
keep them in the same order/sorting they are in, in access. the order and
sorting keeps getting messed up every time I export to excel. The number of
records is usually 30 to 50 rows.
thanks
Al
 
D

Douglas J. Steele

The only way to be sure is to create a query that sorts them in the correct
order, and export the query, not the table.

You should never assume anything about the order of records in tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export from Report's recordsource 1
Export to Excel setting field types 14
export to excel with format 1
Word to Excel: Export comments with text and line number 0
Exporting to Excel from Switchboard (Switchboard Manager) 1
Export Query to Excel command code HELP 2
Export to Excel 2003 with Password 1
Export to Excel 1

Top