Importing data from Excel to SQL

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

Importing data from Excel to SQL

Author

Topic

vbx
Starting Member

38 Posts

Posted - 2008-04-14 : 20:50:04

I am using SQL 2005 the developer edition and need to import a couple thousand records while I try and create a web tool that will filter the data.

I know unltimately I will need to create some sort of application to move the data over. But I am not going to waste my time do that unless I am successful on the web site side.

What is an easy way to import the data. I tried the import wizzard multiple times and have recieved an error...multiple times.

pravin14u
Posting Yak Master

246 Posts

Posted - 2008-04-14 : 23:15:36

Easy way ti import is using the Import wizard. Give the details of the error that you are getting

Prakash.P
The secret to creativity is knowing how to hide your sources!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-15 : 03:18:21

Also refer
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

vbx
Starting Member

38 Posts

Posted - 2008-04-15 : 08:15:29

quote:
Originally posted by pravin14u

Easy way ti import is using the Import wizard. Give the details of the error that you are getting

Prakash.P
The secret to creativity is knowing how to hide your sources!

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "source -Sheet1$" (1.).

I am using Excel 2000 (Until my 2003 version gets here later this week)

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-15 : 09:27:59

quote:
Originally posted by vbx

quote:
Originally posted by pravin14u

Easy way ti import is using the Import wizard. Give the details of the error that you are getting

Prakash.P
The secret to creativity is knowing how to hide your sources!

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "source -Sheet1$" (1.).

I am using Excel 2000 (Until my 2003 version gets here later this week)

I think you need to update Service Pack 1 for SQL Server 2005

Madhivanan

Failing to plan is Planning to fail

vbx
Starting Member

38 Posts

Posted - 2008-04-15 : 16:32:44

quote:
Originally posted by madhivanan

quote:
Originally posted by vbx

quote:
Originally posted by pravin14u

Easy way ti import is using the Import wizard. Give the details of the error that you are getting

Prakash.P
The secret to creativity is knowing how to hide your sources!

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "source -Sheet1$" (1.).

I am using Excel 2000 (Until my 2003 version gets here later this week)

I think you need to update Service Pack 1 for SQL Server 2005

Madhivanan

Failing to plan is Planning to fail

Madhivanan,
Can you tell me what the SP1 will do for me?
Also, am I better off using something other than Excel as my source file?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-16 : 03:01:07

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources