Import from comma delimited text file

[BryanF]

I see a possible problem and would like to hopefully stop it. I'm exporting tables out of databases into comma delimited txt files.... I want to import them all back into one large database. My primary key is actually a driver's license number. My question is... will the transfertext action give me an error when it tries to write duplicate entries from different txt files? and if so...is there a way to have it overwrite or better yet...not import if it already exists?

 

[KF]

If it is possible you should use update and append queries for this operation, if your going from Access to Access. Then adding an updated and Exported field to your tables you can control what information is transfered.

Good Luck,