Run sql script

[jsiimml]

Hi, I have a file with a series of sql statements, eg

-- truncate tables
truncate table test
truncate table test2
etc

To tidy up my database for testing purposes. I was wondering how I can read the file in (tidydb.sql) and run it line by line (ignoring comments and blank lines).

Appreciate the help. Thanks

 

[damber]

Look at the FileSystemObject and the split function (depending on whether your db will handle multiple SQL statements per execution or not) as well as ADO Execute method.



A smile is worth a thousand kind words. So smile, it's easy!