Importing Data from a Text file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 27 May 2005 21:51 GMT

Is there a way of moving data from a linked table to a permanent table. The
"temporary" table is linked to a comma-delimited text file. However, the text
file only holds one set of records at a time. I can import those records.
When the text file is loaded with new imformation, the original data is
overwritten. I am attempting to load the first set of records from the text
file, move those records to a permanent table and then re-load the text file
with new sets of records. Is this possible? Thanks, John

Reply to this Message

Klatuu - 27 May 2005 22:30 GMT

John,
Create a table with the structure of the linked text table.
Link your text table (these two tables cannot have the same name)
create an append query that append to the permanent table from your linked
text table.
run the query. It will add the data from the temp table to the perm table.
Delete the link to the temp table.

If you code in VBA, you can do it all in code; otherwise, you can do it with
a macro

> Is there a way of moving data from a linked table to a permanent table. The
> "temporary" table is linked to a comma-delimited text file. However, the text
[quoted text clipped - 3 lines]
> file, move those records to a permanent table and then re-load the text file
> with new sets of records. Is this possible? Thanks, John

Reply to this Message

Ken Snell [MVP] - 27 May 2005 22:37 GMT

Use an append query to copy data from one table to another.

Signature

Ken Snell
<MS ACCESS MVP>

> Is there a way of moving data from a linked table to a permanent table.
> The
[quoted text clipped - 7 lines]
> file
> with new sets of records. Is this possible? Thanks, John

Reply to this Message