Exporting to Excel 2007 - .xlsx vs. .xlsb

re: Exporting to Excel 2007 - .xlsx vs. .xlsb

ram — Wed, 13 Jun 2012 18:43:03 GMT

Hello Matta,

thanks for your post.

When I did that I am getting an error message like this while connecting to a excel destination.

TITLE: Microsoft Access Database Engine

------------------------------

Could not find installable ISAM.

Can you please help me.

re: Exporting to Excel 2007 - .xlsx vs. .xlsb

Matt Masson - MSFT — Sun, 12 Feb 2012 15:12:17 GMT

I have this magic ability called "Access to the source code" :) It helps to figure these things out.

re: Exporting to Excel 2007 - .xlsx vs. .xlsb

Phil — Fri, 03 Feb 2012 23:11:14 GMT

Thank you Matt, you DA MAN...how were we supposed to figure this out anyways? or how did you ??

re: Exporting to Excel 2007 - .xlsx vs. .xlsb

Matt Masson - MSFT — Wed, 15 Jun 2011 15:05:37 GMT

Bonnie - you can set the connection manager's connection string in the Properties window (press F4 to make it display).

mtCG - You need to hit Enter to commit the connection string changes. Do you perhaps have an expression on the connection manager that is resetting the value? Are you exporting to an existing file, or creating a new workbook with the destination?

re: Exporting to Excel 2007 - .xlsx vs. .xlsb

mtCG — Wed, 15 Jun 2011 14:59:51 GMT

Still doesn't work after making this change. I opened up my SSIS package, clicked on "Connection Managers," then checked "DestinationConnectionExcel" and changed the Connection String as indicated above.

Unfortunately, I still get the error. Am I missing something?

re: Exporting to Excel 2007 - .xlsx vs. .xlsb

Bonnie — Wed, 18 May 2011 04:59:40 GMT

Thank you for your information, but I want to know how and where to set the Excel Connection Manager’s connection string property?

re: Exporting to Excel 2007 - .xlsx vs. .xlsb

PullingOutMyHair — Fri, 10 Dec 2010 22:44:57 GMT

Thanks for this tip. I was about to go crazy trying to export 73,000 rows. I thought there wasn't any support for a true XLSX file.