Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SSIS and Excel 2007 Expand / Collapse
Author
Message
Posted Wednesday, October 29, 2008 4:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 4, 2010 11:33 AM
Points: 43, Visits: 102
Convert to CSV and import. Importing from excel has too many inherent problems. Back in 2002 I wrote a custom parser that had to handle this exact problem because even after hacking the jet drivers registry settings Excel still had problems. Just write it to a text file....It's very easy to write a simple .NET app to convert csvs to text automatedly.
Post #593987
Posted Wednesday, November 5, 2008 11:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 24, 2014 4:31 PM
Points: 9, Visits: 294
GOOD ONE !!! :)
Post #597911
Posted Tuesday, July 14, 2009 2:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 11, 2009 5:40 AM
Points: 45, Visits: 14
guruprasat85 (10/26/2008)
thanks Dinesh but in Sql Server 2005 its easy too.. All you have to do is to use a data flow task and you are on!! :D

Can you elaborate please? I thought what Dinesh described was a data transformation task. You mean there is an simpler more intuitive way? It's not obvious to me.



Post #752510
Posted Monday, August 24, 2009 9:45 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 9:22 AM
Points: 372, Visits: 325
me too getting same error any solution plz
Post #776424
Posted Thursday, June 24, 2010 2:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 25, 2014 4:56 PM
Points: 6, Visits: 176
This is a year later, but maybe somebody finds their way here and encounters the "Test connection failed because of an error in initializing provider. Invalid UDL file." or similar UDL error. I got this and investigated other how-to-define-SSIS-Excel articles. This one
http://blog.tylerholmes.com/2007/12/walkthrough-connecting-to-excel-2007.html
mentioned that you must install "Microsoft Office 12.0 Access Database Engine OLE DB Provider" and gave this MS link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

When I install the MS component and follow the steps in the first link -- they are slightly different from this SQLServerCentral article -- the UDL errors go away.

If an additional download is indeed the fix, then that sucks -- MS gives us the option of picking a Connection Manager OLE DB Provider that is not loaded on the system...ugh.
Post #942691
Posted Thursday, October 28, 2010 3:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:49 AM
Points: 292, Visits: 661
Thanks for the post. It's just helped me out.


Post #1012158
Posted Tuesday, March 22, 2011 11:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 10, 2014 9:03 AM
Points: 103, Visits: 289
Why couldn't I found this two weeks ago when I was nearly in tears over this?! OMG thank you for this.

Amy
Post #1082177
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse