Hello, Need to create a vba module to import an Excel spreadsheet into Access 2003 as a new table,Then append any new data (most new data will match same fields as existing table) to an existing table, bringing over the data as well as any new fields and it's data. I am able to import the speadsheet with no problem using the TransferSpreadsheet module written by Ken Getz. I am unsure of how to proceed, would I be using an INSERT INTO function? Could anyone guide me in the right direction?
Insert Into?
- Thread starter qalalah
- Start date