Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Search results for query: *

  1. papillonNpig

    Excel-to-DB in a batch file

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

    Excel-to-DB in a batch file

    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...
Back
Top