execute SQL by using *.SQL file, is this possible? 1

[LikeThisName]

instead of for instance..

objConn.Execute "SQL STATEMENT"

could i...

objConn.Execute "*.SQL"


LikeThisName <- ? Sorry It's Taken =)

 

[LikeThisName]

i should explain reasoning so someone can tell me a better way.

i need to create 30 tables for each database that is later annointed, so I figured it was possible to write an asp page and that would run the *.sql file I use.

LikeThisName <- ? Sorry It's Taken =)

 

[PHV]

Anyway you can use the FileSystemObject to read the sql files.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[LikeThisName]

Thanks PHV, i think that is what I am going to do.
Just thought their might be a better way perhaps with .NET calling a procedure, but this way will work for time being.

LikeThisName <- ? Sorry It's Taken =)