CREATING A TABLE IN SQL FROM EXCEL

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

CREATING A TABLE IN SQL FROM EXCEL

Author

Topic

tvspsekhar
Starting Member

20 Posts

Posted - 2010-03-08 : 13:04:58

Please help me in creating a table using an existing excel file.

I am having a excel file like this, belonging to a transmission line project with huge data.

Now is it possible to create a table with these columns in SQL , taking all the existing data from the Excel- file?

If so please post the syntax/code for creating the table from excel file.It will be very useful to my construction project.

S No Reach Length

1 1/0 - 2/0 4876.000
2 2/0 - 3/0 201.000
3 3/0 - 4/0 2299.000
4 4/0 - 5/0 494.000

tvspsekhar

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-08 : 13:10:24

make use of OPENROWSET

http://msdn.microsoft.com/en-us/library/ms190312.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-09 : 01:21:31

or see this for more examples
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources