Click on File, Get External data, select file type Excel...
After the table has been imported, create an Append Query to add the tables to the existing table. This will not affect the current records in the table, as you're adding records and not updating them.
Will this also work for a table that has a autonumber in one of the fields. In some cases, the data is from excel and i need to update my table with these requests and have access add the request # once append query is ran.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.