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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
