Hiya..
I've got a plain textfile with a couple of SQL update-statements.
updatefile.sql:
UPDATE lots SET lots.cid = 1123 WHERE (((lots.ID)=23))
UPDATE lots SET lots.cid = 1123 WHERE (((lots.ID)=34))
...
how can i run these in access so that it updates my table.
I looked for an answer in this forum with no success.
I've got a plain textfile with a couple of SQL update-statements.
updatefile.sql:
UPDATE lots SET lots.cid = 1123 WHERE (((lots.ID)=23))
UPDATE lots SET lots.cid = 1123 WHERE (((lots.ID)=34))
...
how can i run these in access so that it updates my table.
I looked for an answer in this forum with no success.