I have a requirement to take an excel report, do much manipulation to the data and create a new worksheet with the data. This part is done.
I decomposed the data so that I could feed it into an Access file with multiple required tables.
I would like to create a table directly from excel and inject it into the access database.
Is this possible? Is it possible to take an existing workbook, open it, move a tab (or multiple tabs) into an access data base as a predefined table name?
Additionally, if the database has the table already, but you want to replace it, can you bypass the warning / querry to replace the existing?
I decomposed the data so that I could feed it into an Access file with multiple required tables.
I would like to create a table directly from excel and inject it into the access database.
Is this possible? Is it possible to take an existing workbook, open it, move a tab (or multiple tabs) into an access data base as a predefined table name?
Additionally, if the database has the table already, but you want to replace it, can you bypass the warning / querry to replace the existing?