Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...

Part and Inventory Search

Back
Top Bottom