Link to home
Start Free TrialLog in
Avatar of Shanan212
Shanan212Flag for Canada

asked on

Appending to Access DB from Excel

Hi,

I want expert suggestion on this.

I have an excel db with unique ID.

I want to create and maintain an Access DB based on this unique ID.

The excel file I get everyweek contains previous 3 weeks of data. So every week, when I append to Access db, I have to remove 2 weeks of data (date method) OR remove all the unique IDs that are present on both files.

I don't want to go through the 'date method' as user entry errors are present in Excel file hence automating it would ruin the db.

I want to know how I can compare each unique ID in excel with Access?

Do I take the access database into a temp table (call it AccessTable), then delete each unique ID that is present on ExcelTable - that just go imported?

^ This seems to be the best idea. However, if  you can show me the resource to compare and delete duplicates inside Access, that would be great.

Rest, I can do!

Thank you for your time!
ASKER CERTIFIED SOLUTION
Avatar of telyni19
telyni19
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial