export problems

  1. M

    Problem exporting time formatted data from Access 2010 to Excel 2010

    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...
    • Morogth
    • Thread
    • access 2010 excel 2010 export from access export problems time format
    • Replies: 0
    • Forum: Excel Questions
  2. M

    User Parameter Query (Acess 2003) to Word Template

    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...
  3. R

    ACCESS TO EXCEL EXPORTATION coming through in a random order (Office 10)

    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...
    • R_McCallan
    • Thread
    • access excel export problems exportation randomised fields
    • Replies: 5
    • Forum: Excel Questions

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top