Exporting Access to Excel Help Please

[graviz]

I'm not sure if this is possible but here is my sitution. I have a table in access that I would like to export to Excel. Easy right? Now I'll thorw you a curve ball. There is a field in there with office locations (which can change based on what they are importing so there's no set names), that I would like to export to a new Excel spreadsheet with tabs based upon the office names. So basically it looks like this:

WO # | Cust Name | Office
123 Joe Office1
3879 Bob Office2
78987 Frank Office1
89090 Jill Office4

I would like tabs of office1, office2, and office4 in this example. Basically I would like tab Office1 to look like:

WO # | Cust Name
123 Joe
78987 Frank


I hope this makes sense. I don't have all of the fields listed but you should get the idea.

 

[Desafinada]

Well, there's not much to change in the transferspreadsheet method, so in your place I would sort the table according to office number, copy all data and write the code to sort them out afterwards. I don't see any possibility for shortcuts.

 

[graviz]

I'm trying to cut the table up into tabs, not nessessarly sort them. Any idea how to do that?

 

[diazr]

I have a MS Access database which I ONLY allow the users to interact within the menu driven macros I have incorporated and buttons etc in the form. On a weekly basis they need to export a specific query into Excel.

Can someone help me on how I can incorporate in my menu the EXPORT feature to that specific query.

Thanks.

 

[dbDamo]

I have a MS Access database which I ONLY allow the users to interact within the menu driven macros I have incorporated and buttons etc in the form. On a weekly basis they need to export a specific query into Excel.

Can someone help me on how I can incorporate in my menu the EXPORT feature to that specific query.

Thanks.

Create a new macro and use the TransferSpreadsheet action to perform the export. You could also use the RunApp action afterwards to open the Excel file if the user needs to view it.

Then just add a new button onto your menu which will run this macro.