Download data from linked table

[Seabz420]

Here's the problem...
I have 88 tables (2 of them are linked tables). What I need to do is import data (into these 2 tables) from another datasource based on queries that are set up. For instance:
I have a query that looks at all the records in the "DEPLN" table and pulls out only the Loan data. I have another query that looks at the "DEPLN" table and pulls out only the Deposit data. How do I initiate the import of the data from the datasource based on the query?

 

[TheAceMan1]

How are ya Seabz420 . . . . .

Have you tried an [blue]Append[/blue] query using one of your queries as the data source! Here's a single field example:

[blue]INSERT INTO LinkTableName ( LinkTableFieldName )
SELECT QueryName.QueryFieldName
FROM QueryName;[/blue]

Where the SQL for QueryName is something like:

[blue]SELECT FieldName
FROM TableName In "C:\Path\FileName";[/blue]

See Ya! . . . . . .