Murray Brown
asked on
Access VBA - Loop through Excel sheets and import the to the same table
Hi
I have an Excel spreadsheet with data on several sheets. They all have the same column names.
What Access VBA code would I use to append all the data to one Access table?
Thanks
I have an Excel spreadsheet with data on several sheets. They all have the same column names.
What Access VBA code would I use to append all the data to one Access table?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER