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.
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 errorTITLE: 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"; |
|
|
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. |
|
|
|
|
|