Importing *.txt files into multiple tables in access 97

[Daz]

Hi,

I have managed to create an export and import test routine for my dbase. What it does is the record that i am currently viewing on the form can be exported as one record only, this works fine with data from just one table. The way I collate the data to be exported is through a query.

The problem is the data that i need to export\import is in multiple tables. ie (Customer_Tbl and Comments_Tbl)and linked on the customers details on the form that i view. The export of the data is no problem, but how do i import the right data to the two tables? I created a specification file for the export\import, but i could not see how to inform the specification file that the data needs to be put into the two tables.

Can it be done, if so how?

Many Thanks

Daz

 

[MichaelRed]

Can not do this (directly) through the import/export spec.

You COULD create a 'transient' table with all of the fields for all of the various tables and parse (use a series of append queries from the trransient table to the final tables) this info out to it's final destination.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[MichaelRed]

Sorry, forgot to note:

be sure to delete the entry (or entries) in the transient table after the transfer to the final tables.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over