Importing Data from a Text file

[Guest]

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

 

[Guest]

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

 

[Ken Snell [MVP]]

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