Append Query/table with Link Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I think I need a MVP! I have a linked CSV file which essentially gives me
all the data I need. I left 2 columns within this csv file blank (packed
and run order) so that I could use these columns to manipulate the data.
Meaning I could use Packed which is a yes/no checkbox to say not to show the
fruit which has already been packed. Then I could review the remaining
unpacked fruit and use runorder column to insert a number to sort what grade
I will run with each time. This sounds really confusing but its not. Trust
me the design of this database is good. How would I append new data to an
existing table if the table I need to add to is a link? or what other
suggestions
 
Your problem starts from a wrong assumption: you can update/append a
linked table just fine, but not a linked text file! Import into a native
Access table and make all the chnages you need. If you still need the
CSV file, re-export when done.

Note: in theory you could use some rather extensive code to work on the
text file directly (especially the updating of existing records is a
dog), but it's quite inefficient and, really, just not worth the trouble.

HTH,
Nikos
 
This is a text file that is linked. Is there a way I can run a query or
place this information and also update it to be able to manipulate it. And
if you answer is import into an access table then how will it update. thanks
for your help
 
This is a text file that is linked.
Click to expand...
Yes, that's clear.

Is there a way I can run a query
Click to expand...
You can run as many select queries as you like, but no action queries
(append, update, make-table, delete). To Access, a linked text file is
essentially read-only; Access can't make in-file changes in a text file,
in the way an editor / word processor would.
or place this information and also update it to be able to manipulate it. And
if you answer is import into an access table then how will it update.
Click to expand...
Yes, the answer is indeed: import into Access. Having the text file as a
linked table, make an append or make-table query on it, to put all the
original data in a native Access table. Make all your changes in that
table, then when done re-export the table to a text (.CSV) file, like
the original one.

HTH,
Nikos
 
Back
Top