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