Import data from Excel file in Access VBA code

[ns44]

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.

 

[Joe4]

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.