SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Can we use .Xlsm as Excel source
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

goodsolution
Starting Member

38 Posts

Posted - 05/06/2009 :  09:07:26  Show Profile  Reply with Quote
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

United Kingdom
616 Posts

Posted - 05/06/2009 :  15:28:51  Show Profile  Reply with Quote
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

USA
1 Posts

Posted - 07/25/2013 :  11:15:01  Show Profile  Reply with Quote
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.

Edited by - JIMMYDU on 07/25/2013 11:16:10
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000