EXPORTING TO EXCEL

[gearhead03]

I have a report that I would like to export to Excel. I can set up the report to goto preview mode and then click analyse in excel. However, I can only mike it work for one day. At the end of the day I export to a file then I copy and paste to a file that runs for the week. I would like to be able to export at the end of each day into a file that is complete at the end of the week without having to copy and paste.

Mark A. Kale

 

[batteam]

Try looking into the Transfer Spreadsheet command. Access 'Help' files will give you all the parameters you need to export a table or query into Excel. Although each time you use this command, a new Excel file is created (sorry, this command cannot EXPORT data into an already existing Excel file), you can use macros in Excel to open, copy and paste each preceeding day's export data on the file your transfer created that day, thus building up your main Excel sheet as the week progresses. Macros in Excel are easy to do and can be used in some very, very creative ways.

Another method you could try is, from Excel, import the data using Excel's import query process. From |Data|on the Menu bar, go to |Get External Data| then |New database query| and follow the wizard prompts. Again, very easy to use once its set up right.

So, you can either export from Acess with the TransferSpreadsheet command or start from Excel and import Access data into it using the import query process.

Hope this gives you some direction. Good Luck