Excel-to-DB in a batch file

[papillonNpig]

I have a select statement that works in Query Analyzer.

SELECT * INTO TableName FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=drive:\DirName\FileName.xls', [SheetName$])

Can I put it in a batch file? Just tried the isql command,

isql -S"Servername" -d DBname -E /Q "<The select statement>"

didn't work. Any suggestions?

 

[papillonNpig]

I already figured out! Put the script in a .sql file, then use the isqlw command. Thanks for reading