Exporting Query Data From Access to Excel

[Jack58]

I am having a problem with Exporting information from a Query to an excel file. I can get the data to export, however the data is not kept in the same order as in the query(whick is very important).

Is there any way to export into an Excel 200 XLS file without going through an Automation procedure?

Any help on this subject would be greatly helpful.



Jack

 

[wemeier]

Have you tried adding an ORDER BY to your query to sort the records before exporting them?

 

[Jack58]

I only want to sort the heading in the specific order I have them laid out in the Query. Will this command sort the "Records" or the data format I need to keep in order?

Thanks!!!

 

[wemeier]

I'm not sure I understand. Are you saying that the COLUMNS are in a different order in Excel than Access? I export to Excel all the time and I've never seen this happen. If that's the case, I'm sorry but I have no answers for you.

 

[Jack58]

When I run the Macro Containing the SendTo Macro Command, the data is in a different order than the order the data is in the Microsoft Access 2000 Query.

I know that I can make an Automation Procedure to extract the data, however that is a lot of work and time I don't have at this time.

Please let me know your procedure for Extracting from Access to Excel.


Thanks



Jack