>Is there an easy way to upload an excel spreadsheet to sqlserver from within excel
>maybe with a script or so
>
>
>Our .net/sql guy has real problems with ssis
>
>Peter
This link shows several options:
https://support.microsoft.com/en-us/kb/321686While SSIS can be a bit tricky, I'd still recommend SSIS. Some of the problems in loading Excel data via SSIS are problems you might also run into with other tools - namely, handling the data types.
Any time I have to read in Excel data, I always try to see if the data can first be saved as CSV instead. Obviously that's not always possible, but I still try at the beginning.