Second time I ask, can ANYONE help me???

[Kenneth]

I need a import and export function in my database. But the import and export wizard that is already in Access, is not good enough for what I want to make.
I have a database with 5 tables and lots of fields in them. I want the user to select the correct item to export, and then it should collect all the field values from all the 5 tables (as they are linked together with an ID) export them to ONE .txt file.

And the opposite when importing. I want to import the txt file, and when this is done, all values should be inserted at the end of the list in all the 5 tables.

Is this possible or what?
ANY help would be nice, as I'm lost.

 

[Pat Hartman]

You can export the data from all 5 tables by creating a query and then using that as the recordsource for the TransferText Method/Action.

The import is more difficult. You can import the text file into a new table. You will then need 5 append queries to select the relevant data from the new table and append it to one of the 5 original tables.

 

[Kenneth]

Thanks for your answer. I will try your solution. Thanks alot for answering my question.

Best regards
Kenneth