How to use VBA to import excel file / worksheet into access database as a new table, not an established table already there. Could someone provide an example code.
How to use VBA to import excel file / worksheet into access database as a new table, not an established table already there. Could someone provide an example code.
docmd.transferspreadsheet....
but why would you keep importing new tables?
all your tables should already be established.
Alternative is to link the excel range/table to Access.
John,
I agree with ranman are you importing new tables repeatedly?
Perhaps you could give us some info re the need and the business process involved.
In many situations, you establish the table design in Access, then import the data from Excel (or other).