Hi all. I'm having a problem exporting an Access 2010 query to Excel. The Access query contains a number of text and numeric fields which export with no issues. However, one of the fields is in a time format ([nn]:ss) which, when exported to Excel, fails to transfer the values.
The database...
Hi,
i am struggling with how to effectively 'export' the results of a query into a word template, where the query prompts the user for a query parameter.
I have set up the word template (.doc) and added in bookmarks to send the query data too but I cannot seem to get my head round how to...
I have exported some data from Access to Excel (2010) and once exported to access the data is in a different order from when it was in the query. The data is all under the correct headers but each column is randomly ordered.
The query is in the following order (by fieldnames) CompanyName...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.