Import Help Needed

[matt001]

Hi

I have got a Microsoft Access Database table with a few hundered records, I have got a excel or csv file with the same table but its got changes, deleted records and new records added.

What I want to do is replace the info in the access table with the new data that I want to import in. But I don't want duplicates and I want it to add, delete, modify records.

I know in MySQL you can use a Replace Query that does what I want. But the database I am working on is Microsoft Access.

Is their a solution in MS Access that I can tell it to point to a Excel Spreadsheet, or csv file and replace existing records with the changes, delete and add.

Matthew

 

[johncallaghan]

You can use ''File', 'Get External Data', 'Import' to import your excel file into access into a new table. You can then perform an unmatched query on the two tables and decide what to do form there.

 

[matt001]

How do I create an unmatched query on the two tables

 

[Bat17]

What I want to do is replace the info in the access table with the new data that I want to import in. But I don't want duplicates and I want it to add, delete, modify records.

sounds like you just want to delete all the existing data and replace it with the new

Peter

 

[johncallaghan]

Generate a new query and select 'find unmatched query wizard'. the wizard will guid you through it. If you are not sure just do it and see what the result is. you will soon realise if you have done it the wrong way round.