Importing data from Excel to Access 1

[kastaman]

I require to update my table in access from an excel file.
How can I accomplish this without affecting the records in the table?

 

[nmc1975]

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.

norm

 

[kastaman]

Thanks nmc1975.

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.

Thanks,

Kastaman