export access query

  1. U

    Exporting Multiple Queries on different worksheets of a workbook

    Hello I am new with Access and VBA, My purpose is to export Queries in one workbook but different worksheets. I am working with Access 2007. When I add an Ouput file for the Queries to go in a specific workbook I get a compiling error stating: "Compile error.in query expression...
    • Umutony
    • Thread
    • access & vba access 2007 export access query transferspreadsheet
    • Replies: 2
    • Forum: Microsoft Access
  2. T

    Exporting data to excel, losing data

    Hi all! I have a problem with exporting data out of Access. When I export database from Access to Excel file, the amount of data is less than what I would get when i do this manually. How could that be? I have 3 filters in my query, I press Run! - This gives me total amount of 2459. and when...

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
Back
Top