How do I refresh an already created table?

[ActionMike]

I have created a table via importing a CSV file. The CSV file was recently
added to and I want to import this information into the already existing
table. How?

 

[Paul Hammond]

No doubt you may get a professional reply to this, but here are a few thoughts.

1. Do you have a unique identifier in the CSV file that you imported as a
primary key? If so you could import the same file into the table and only
new records would be imported.

2. Depending on your situation, you could purge the existing data and
import the entire new file.

Of course, back up your table just in case.

Hope this helps.

Paul

 

[Jeff Boyce]

By "this information", do you mean the "recently added to" information, or
the entire CSV file?

If the former, how do you know which data/records were those "recently
added"? That's how you'd tell Access which ones to use.

Or another possibility is to import the entire CSV file, then parse it into
your more permanent, well-normalized Access table structure using queries.
Only rarely are CSV files particularly well-normalized...

Regards

Jeff Boyce
Microsoft Office/Access MVP