How do I execute multiple SQL Statements in Access’ Query Editor?
You can easily write a bit code that will read in a file. You can either assume one sql statement per line, or assume the ; So, assuming you have a text file such as: insert into tblTest (t1) values (‘2000’); update tbltest set t1 = ‘2222’ where id = 5; insert into tblTest (t1,t2,t3) …