The biggest challenge I’ve had in a long time is trying to import Excel spreadsheets into a staging table. Ridiculous you say?
I would agree. The ultimate production box is 64 bit Windows 2003 server with Sql Server 2008 R2 installed.
I need the package to accept either 2003 or 2007 Excel formats.
The sheets to import all have identical column names but the columns contain disparate data. Meaning sometimes a specific column has text and sometimes it has numerical data. I have zero control over that particular aspect.
I don’t want the driver to take it’s best guess as to the data format, I just want to stage the data into a Sql Server table with
Yes I have the Microsoft.ACE.OLEDB.12.0 driver loaded on the server and yes I have tried adding the IMEX=1 to the connection string.
I have tried running the import via a stored procedure and for the m
View Complete Post