I am trying to copy a table in Excel to SQL. I am using a Bulk Insert in a stored procedure. With the bulk insert I just need to give the Excel file path and name. There is two worksheets in the Excel spreadsheet and I believe that the problem is that it is trying to copy the data from the wrong worksheet and is giving me a wrong column type error.
Is there a way to reference a specific worksheet in a Excel file?
Or does anyone know of another way to copy a Excel table to SQL programtically?
I am also first to admit that I don't really know much about Excel, but I am strong with database basics.
Thanks
Is there a way to reference a specific worksheet in a Excel file?
Or does anyone know of another way to copy a Excel table to SQL programtically?
I am also first to admit that I don't really know much about Excel, but I am strong with database basics.
Thanks