I was importing data from Excel to SQL 2005

I was importing data from Excel to SQL 2005 by using SQL Server Import and Export Wizard.
At the end of the last step, it gives me this error 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)


+++++++++++++Below are the complete Report:+++++++++++++++++++++++++++



Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

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

- Prepare for Execute (Stopped)

- Pre-execute (Stopped)

- Executing (Success)

- Copying to [test].[dbo].[Sheet1$] (Stopped)

- Post-execute (Stopped)

- Cleanup (Stopped)

What do I do?
Thank you
erin027Asked:
Who is Participating?
 
imitchieConnect With a Mentor Commented:
text from the link:

Solution: Install SP1 for SQL Server 2005 on the client machine. This will update the import files and the error will go away.

If the error does not go away, here is a great site on Microsofts MSDN site that discusses this error:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.