Importing of data from Excel/Access to two tables linked by a querry

[lranganathan]

Dear Sir/Madam,

I am having the problem of importing a database from Excel/Msaccess 2000 to a Msaccess 2000 database from which the data was originally exported. The Database consists of two tables connected in a querry and the two tables has a unique primary key thru which the two tables are linked using a querry. While importing only two tables are listed in the importing wizard and not the querry.

So how to import the data to the two tables connected by a querry using a primary unique key.

help me the procedure.
lrnathan
thanks in advance

 

[neileg]

You can't import the data that the query returns directly. You have two choices.
1) Import the two tables and then import the query definition and run the query to get the data
2) Export the query data to an external file and import that