Question:
Can you import Excel files into SQL Server tables using bcp? if so what is the command line?
Answer:
You can’t execute bcp directly against an Excel file. However, Excel gives you the option of saving your worksheet as comma-delimeted or fixed length. You can then run the bcp command against the text file that has been created. The online books has a complete section on the command line parameters of bcp.