import data from access

  1. K

    VBA to retrieve Access tables to populate worksheets in Excel...

    Hi all, I was wondering if there was some VBA code that could be used to retrieve tables from Access to populate multiple tabs to an existing Excel document? Or create a new document. I suppose either would work. Please and thank you. Also posted in Access forum here...
    • kyleno
    • Thread
    • excel excel to access excel to access using vba import data from access vba
    • Replies: 1
    • Forum: Excel Questions
  2. K

    Copying Data from Access HELP

    Hi, I'm having trouble copying data from Access into excel. I have the following code: Option Explicit Dim RecordSet2 As ADODB.RecordSet, ExternalAccessTable2 As ADODB.Connection Sub testcode() Set ExternalAccessTable2 = New ADODB.Connection Set RecordSet2 = New...
  3. F

    importing required data from access database file

    Dear All, I need to import data from acces DB file, with Pivot table, but my query is, there are 10,000 rows data in DB file , i just want to import data after 5000 rows, till the end, for example: i dont want to import data from 1st to last i want to import from data from 5000 to last, or...

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