Novice
Windows 7 64bit 
Access 2010 32bit
I am looking for the VBA used to import multiple column ranges from an Excel spreadsheet to Access (ie: "A:V", "X:Z"). I am able to do this through a saved import, yet have not found a way to edit anything other than the file locations for those imports, so am thinking VBA is the way to go.
VIP
Windows 10 Access 2010 32bit
not quite sure what your question is but with vba you would use the transferspreadsheet method, although I'm not sure you can import multiple ranges into a single table
You would probably be better to link to the excel file (also using transferspreadsheet) then an append query to copy data from the linked table to the destination table/s.
MS MVP - Access Expert
Windows 8 Access 2013
This might help:
Import Excel Date
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Importing multiple files from excel into a table and also inserting the file name into a column
Calender to select ranges from Access to Excel using VBA
Posting Permissions
Reply With Quote