Jeff Moden wrote: homebrew01 wrote:
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual spreadsheets ((but I could be wrong there). I believe you'd have to export the spreadsheet to a CSV or TSV for BCP to work.
Of course, if I am wrong about that, I'd love to see the BCP command line that does it because I love learning. 😀
If it's an occasional manual process, the XLSX could be "SAVE AS" a CSV. If that works, it might be easier to re-run BCP using the saved code, rather than step through the Import Wizard again.
Also, the Import Wizard process can be saved as an SSIS package at the end to be used again later.
Disclaimer: I don't do much in MSSQL these days so I may be off base somewhat.