re the rounding due to Excel formatting

and following Eirikur's example

I decompressed an .xlsx (rename to .zip and unzip) and had a look.

The sheets ar in \xl\worksheets and contain the...

Hi Jeff

Thanks for your reply.

I've seen your stuff at detroit.sqlpass.org and as usual learned a few tricks from it, before trying it.

Works great on 2008R2 after replacing (local) with...

Interesting topic, with interesting contributions

We too get .xls, .xlsx, and .csv in ever changing formats and need to feed this into a SQL server Db.

It's healthcare data, coming in from...