Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Can we use .Xlsm as Excel source

Author  Topic 

goodsolution
Starting Member

38 Posts

Posted - 2009-05-06 : 09:07:26
Can we use .Xlsm (ExcelMacro-enabled worksheet) as a Excel data source in SSIS? Because while i am using this as a source it is throwing me the following error

TITLE: Microsoft Visual Studio
------------------------------

File path contains invalid Excel file. Please provide file with .xls extension.


If we cant use this, what is the soultion to change .Xlsm to .Xls?

-Thanks

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-05-06 : 15:28:51
What is your connection string?

Try this from http://www.connectionstrings.com/excel-2007 :
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;Extended Properties="Excel 12.0 Macro;HDR=YES";
Go to Top of Page

JIMMYDU
Starting Member

1 Post

Posted - 2013-07-25 : 11:15:01
I need some solutions to work on .Xlsm with PHP or some solutions to change .xlsm to .xls. Do you have some solutions? I really appreciate your helps.
Go to Top of Page
   

- Advertisement -