Import Help

[TimE]

I need to import a text file (; seperated):

Append if record does not exist, update certain fields if record exists then rename the text file so I can archive.

Possible?

[XLGibbs]

Import the text file into it's own table. Run an Append query to add new records to the main table. The run and update query and join on primary key to the Imported table to update the applicable records with new information. you can specify the fields to update in the Update query.

Once done, you can just export the import table to a text file and name it as needed. Once the queries are set up you can use macro designer to layout the order of events to run in sequence automatically.

Welcome to VBAX!