Import data from Excel file in Access VBA code

ns44

New Member
Joined
Jun 15, 2009
Messages
16
Hi,

I would like to ask, if anybody knows a vba code which will enable me to import data from Excel file to Access Database? I need to import only selected named range and paste data in existing table in Access (to the first empty line). I know how to do it while using Import Spreadsheet Wizard but l need to automate this process. Could anybody help me with my issue??

Thanks a lot,

N.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
64,001
Office Version
  1. 365
Platform
  1. Windows
Take a look at the "TransferSpreadsheet" Macro action. If you create a Macro that basically does this (there is lots of help with the arguments), you can convert these Macros to Visual Basic code (under Tools | Macros ...) in pre-2007 versions of Access.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,196
Messages
5,857,880
Members
431,905
Latest member
RW11700

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