Help updating table from linked table(linked table is a csv)

  • Thread starter Thread starter Thierry
  • Start date Start date
T

Thierry

Hi

I need some help. Im trying to update my access database with the values
from a linked table.

tblGoods is the one to be updated. it contains wholesalestock wholesaleprice
and some other fields.

im trying to update those from my table updategoods which is a linked table
(csv).

I have tried

UPDATE tblVare INNER JOIN tblTmoVare ON tbltmoVare.Varenr = tblVare.Varenr
SET tblVare.WholesaleLager = tblTmoVare.WholeSaleLager,
tblVare.UdsalgsprisInclMoms = tblTmoVare.Udsalgsprisinclmoms;

but i get an error stating this is not supported by the isam.

please help.
 
I don't think you can change any data in a CSV text file. I could be wrong.

You might try importing the data into a table, editing there, and then exporting
it back out.
 
Im not trying to edit the csv file. That is the source for updating the
database table - which is tblgoods.

at the moment im running through all lines in my csv file and then run an
update query for each row in the csv file.

This is rather slow so i was hopeing that it might be posible to run an sql
query instead.

hope someone can help me.

Thierry
 
Back
Top