Export Excel 2007 in Sql db using Sql Server

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

General SQL Server Forums

New to SQL Server Programming

Export Excel 2007 in Sql db using Sql Server

Author

Topic

arorarahul.0688
Posting Yak Master

125 Posts

Posted - 2009-09-15 : 01:04:25

Hi Every one,

Can any one please help me to import data from Excel 2007 sheet(etxtension ".XLSX") in a database in Sql Server 2005. I tried this using SSIS packeg but got error invalid excel version while using excel source object. similarly i m having a maximum excel version option 97-2005 while importing data using Database->Task->ImportData-> DataSource->Excel 97-2005.

Please give me your valuable ideas to import excel 2007 in SQL Server 2005

Thaks All,
Rahul

Rahul Arora
NCCE, Panipat

######################
IMPOSSIBLE = I+M+POSSIBLE

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-09-15 : 01:14:19

see this link
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-09-15 : 04:46:50

To connect to Excel 2007 you need to use the ACE OLEDB driver

For connecting to Excel 2007 files with the Xlsx file extension:
http://www.connectionstrings.com/excel-2007

2007 Office System Driver: Data Connectivity Components
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources