Can you tell me about appending in Access database?

[llively]

How can I append(import) addtional data into an exsisting database and have it omit duplicates from several Excel spreadsheets. Also, what is the max records in Access databases?

 

[JeMK]

Hi

A rather long hand but effective way of doing this could be to combine all the data in one excel spreadsheet, use the filter by form in Excel to remove duplicates, then import the data into the access table.

Good luck!

 

[DISI]

Another way that's not difficult at all is to set a primary key in your Access table. This prevents appending duplicate records. Next link to the excel spreadsheets. Use an append query to add the data to your Access table. Access will automatically "kick out" the duplicates.

If you need help with primary keys or append queries let me know.

Paul Paul Faculjak
paul@DataIntegritySolutions.com

 

[llively]

Thank you for the information. Some of the databases I am building have up to 300,000 line items. Which is close to 3 1/2 times the capacity of an Excel spread sheet. This data is being made available for quick searches of our support team.