Thanks, he found his problem. It had to do with 32 vs 64 drivers
Peter



>>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/321686
>
>While 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.