papillonNpig
Computer
- Oct 6, 2005
- 2
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?
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?