Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
1 Points
69 Posts
Apr 30, 2012 05:43 PM|LINK
Looks like the problem was with my connectionstring. The one posted above worked on my local box, but on the server I had to switch it up by file type and add IMEX:
<add name="xls" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 8.0;IMEX=1';" /> <add name="xlsx" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0 Xml;IMEX=1';" /> <add name="xlsm" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0 Macro;IMEX=1';" />
Switching to these and appending the file location worked to get the full import running.
Now on to the next problem!
DonL
Member
1 Points
69 Posts
Re: OleDbDataReader stopping prematurely with no error
Apr 30, 2012 05:43 PM|LINK
Looks like the problem was with my connectionstring. The one posted above worked on my local box, but on the server I had to switch it up by file type and add IMEX:
<add name="xls" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 8.0;IMEX=1';" /> <add name="xlsx" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0 Xml;IMEX=1';" /> <add name="xlsm" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0 Macro;IMEX=1';" />Switching to these and appending the file location worked to get the full import running.
Now on to the next problem!