Excel 2007 import into SQL 2008

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 2008 Forums

SSIS and Import/Export (2008)

Excel 2007 import into SQL 2008

Author

Topic

Cry
Starting Member

24 Posts

Posted - 2009-08-20 : 05:12:23

Hi,

i hope someone can help me. I have a problem with the import of an excel 2007 sheet into sql 2008 via SSIS.

i always get an error message because of text was cut what results in an other error message "DTS_E_PRIMEOUTPUTFAILED".

In the preview of the connection manager all values are correct, but the dataflow does not work.

Used components:
SQL Server 2008
Excel 2007 Sheet
Win Server 2008 Std. 32Bit SP2
OLDB Provide Office 12.0 Access

regards
Jo

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-20 : 05:54:20

Excel 2007 doesn't use OLEDB anymore, it uses ACE.
See http://www.connectionstrings.com/excel-2007

N 56°04'39.26"
E 12°55'05.63"

Cry
Starting Member

24 Posts

Posted - 2009-08-20 : 06:18:06

Hi,

sorry, thats correct, but it doesnt change anything on the result. The error still occurs.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-20 : 15:48:22

What is the complete error message?
Does it error for every line in the Excel file?
What is the longest line of text in the Excel file? And what is the datatype and size of the column it maps to in the table?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources