question

sreevardhan avatar image
sreevardhan asked

store excel data into sql server

i have more data with many columns in excel,how to store all data into sql server database. thanks in advance
excelsqlserver2012
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
Forgive me, can you clarify your question further? You have an excel file with many columns that you need to store now in a SQL database? What problem are you running into?
0 Likes 0 ·

1 Answer

·
borispinsky avatar image
borispinsky answered
You can use openrowset http://shahzy1.blogspot.co.il/2012/11/configuring-openrowset-in-sql-server.html
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.