Run SQL queries from textfile

[delpino]

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.

 

[THoey]

Hmmm... Create a table with a text field, import the text file into the table, loop through the table and for each record, load a txtString variable and run the DoCmd.RunSQL passing it that string? Terry M. Hoey

 

[delpino]

is there an easier way to do that? my programming skills in access are not very good.

in phpMyAdmin (for MySQL) you just point to the textfile and execute it..much easier