Append text (.txt) file to an existing table

G

Guest

I have a table with annual data already in it. I need to add an additional
year that is currently stored in a text file. (The text file has the same
data structure as the existing table.)

How do I append the text file to the existing table? I'm fine with doing
this manually... I'm putting together a fairly simple table.
 
G

Guest

In the Tables Tab of Access, File Menu | Get External Data | Import...In the
Files As Type choose text file, find your file that contains the data you
want, and follow the prompts.

Hope this helps.
 
L

LEECATES

Ed said:
I have a table with annual data already in it. I need to add an additional
year that is currently stored in a text file. (The text file has the same
data structure as the existing table.)

How do I append the text file to the existing table? I'm fine with doing
this manually... I'm putting together a fairly simple table.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferText - Append to existing text file 2
query to append and update? 4
Importing text file with append 1
best way to update table 2
Append query and combo box on the form 1
APPENDING TO A TABLE WITH DATA 7
How to add an additional field in the existing database table 5
Export an Access table to an EXISTING Oracle Table 1

Top