Export Excel data to existing sql server table

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)

Export Excel data to existing sql server table

Author

Topic

sri2000
Starting Member

2 Posts

Posted - 2011-02-17 : 20:30:02

Hi

I need to export the excel data to existing table in SQL SERVER 2008.
The data in excel is having quantity details on weekly basis as below

Date 13-08-10 20-08-10 27-08-10
Name Type Qty
P1 D1 100 200 200
P2 D1 200 300 400
P3 D1 100 200 500

I need to export the above data to below existing DB table

Table
-----
Name
Type
Date
Qty

How can I export this data using queries?

Thank you.

edit: moved to proper forum

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-02-17 : 21:09:22

you can refer to this thread http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

KH
[spoiler]Time is always against us[/spoiler]

sri2000
Starting Member

2 Posts

Posted - 2011-02-18 : 12:03:05

Thank you for reply.

I read the thread. Do I need to change the data format in excel sheet as below before using the query?

Name Type Date Qty
P1 D1 13-08-10 100
P1 D1 20-08-10 200
P1 D1 27-08-10 200

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-02-24 : 03:20:41

quote:
Originally posted by sri2000

Thank you for reply.

I read the thread. Do I need to change the data format in excel sheet as below before using the query?

Name Type Date Qty
P1 D1 13-08-10 100
P1 D1 20-08-10 200
P1 D1 27-08-10 200

If the table has this format, then you need to change the data format

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources