Exporting to Excel
- Thread starter jchelsen
- Start date
I am using Access 2007. I am running my query, when the results come up I click on External Data, then Export, and open up the Export pop-up screen. I identify the filename for the exported data, including the directory (a shared directory on a LAN), and click ok. I receive a message that the file has been successfully exported. The pop up screen returns, asking if I want to save my export steps, after clicking on yes, the defaults open up, and I use the defaults on the screen. When I click on Save Export, that is when the error comes up.
- Local time
- Today, 22:59
- Joined
- Feb 19, 2013
- Messages
- 17,694
I can't replicate that error and have little experience of exporting in this way. However I wonder if the query is referring to forms which aren't open or accessing data which may not always be available (e.g. linked table to excel or csv file).
Also, have a look at this link
https://support.office.com/en-nz/article/Export-data-to-Excel-64e974e6-ae43-4301-a53e-20463655b1a9
looks like you need to specify a name for the specification - perhaps the default is insufficient.
Sorry I can't be of more help
Also, have a look at this link
https://support.office.com/en-nz/article/Export-data-to-Excel-64e974e6-ae43-4301-a53e-20463655b1a9
looks like you need to specify a name for the specification - perhaps the default is insufficient.
Sorry I can't be of more help
Libre
been around a little
- Local time
- Today, 14:59
- Joined
- May 3, 2007
- Messages
- 683
you might check out this command:
docmd.transferspreadsheet
here is an explanation of the arguments and syntax:
https://msdn.microsoft.com/en-us/library/office/ff844793(v=office.15).aspx
I've used this method quite often and I admit that it has been touchy sometimes - you have to make sure the spreadsheet to accept the data is NOT OPENED when you perform the export. I like this method as opposed to manually exporting (and of course you can copy and paste from Access to Excel and visa-versa). Once you get the transferspreadsheet method down, you can then just put a command button anywhere that when clicked will execute the command! Saves time and trouble rather than doing the transfers "on the fly".
docmd.transferspreadsheet
here is an explanation of the arguments and syntax:
https://msdn.microsoft.com/en-us/library/office/ff844793(v=office.15).aspx
I've used this method quite often and I admit that it has been touchy sometimes - you have to make sure the spreadsheet to accept the data is NOT OPENED when you perform the export. I like this method as opposed to manually exporting (and of course you can copy and paste from Access to Excel and visa-versa). Once you get the transferspreadsheet method down, you can then just put a command button anywhere that when clicked will execute the command! Saves time and trouble rather than doing the transfers "on the fly".
