Error While Importing Excel Spreadsheet

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

SQL Server Administration (2005)

Error While Importing Excel Spreadsheet

Author

Topic

Plaid_Dragon
Starting Member

7 Posts

Posted - 2008-12-11 : 18:54:43

I'm attempting to import data from an Excel 2000 spreadsheet into
a standard edition sql server (9.0.3073).

It fails with the following message:

- Validating (Error)

Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - Sheet1$" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (63).
(SQL Server Import and Export Wizard)

I've verified that the SSIS service is, in fact, started. I restarted the service but that had no effect.

The spreadsheet is formatted as text and the columns are all varchar(100).

Ideas on how to solve it?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-11 : 19:37:40

I guess SSIS or Export/Import Supports only Excel 2003 onwards.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-12-12 : 01:55:54

You need to install latest service pack for SQL Server 2005

Madhivanan

Failing to plan is Planning to fail

Plaid_Dragon
Starting Member

7 Posts

Posted - 2008-12-19 : 17:44:26

I downloaded SP2 from microsoft and verified it was what the server already has.

I'm still getting:

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - Sheet1$" (1).
(SQL Server Import and Export Wizard)

...when trying to import a Excel 2000 document.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-19 : 17:47:52

quote:
Originally posted by Plaid_Dragon

I downloaded SP2 from microsoft and verified it was what the server already has.

I'm still getting:

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - Sheet1$" (1).
(SQL Server Import and Export Wizard)

...when trying to import a Excel 2000

document.

SP3 is already out in market.

Plaid_Dragon
Starting Member

7 Posts

Posted - 2008-12-19 : 18:50:18

Thank you for the information regarding SP3.

I successfully installed the service pack and rebooted the server. All SQLServer services, including SSIS, are up and running. Version is now 9.0.4035 and the same error still occurs.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-19 : 22:48:48

quote:
Originally posted by Plaid_Dragon

Thank you for the information regarding SP3.

I successfully installed the service pack and rebooted the server. All SQLServer services, including SSIS, are up and running. Version is now 9.0.4035 and the same error still occurs.

Can't you get excel 2003 (office 2003)?

Plaid_Dragon
Starting Member

7 Posts

Posted - 2008-12-29 : 12:59:11

I can (and did) save a excel 2007 document as "97-2003" format. That did not make any visible difference. In addtion to not recognizing the 97-2003 file, SQL 2005 doesn't seem to want me to select a 2007 "xlsx" file.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-29 : 15:06:53

quote:
Originally posted by Plaid_Dragon

I can (and did) save a excel 2007 document as "97-2003" format. That did not make any visible difference. In addtion to not recognizing the 97-2003 file, SQL 2005 doesn't seem to want me to select a 2007 "xlsx" file.

did you try importing file using OPENROWSET instead?

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-12-30 : 01:58:02

Find it in this page
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926&whichpage=17

Madhivanan

Failing to plan is Planning to fail

Plaid_Dragon
Starting Member

7 Posts

Posted - 2008-12-30 : 08:57:57

I'll try that, thank you very much.

I'd still like to know why the error I listed above is occurring though.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources