Excel To Sqlserver Database

Question

0.00/5 (No votes)

See more:

Hello,
I have some data in my database.

What i want to do is i have to import the table data to Excel and after doing some changes in Excel sheet i need to update my database according to the changes made in Excel.

Posted 8-Aug-13 20:23pm

bakkupavan

Add a Solution

Comments

Karwa_Vivek 9-Aug-13 2:44am

why dont you use the IMPORT and EXPORT wizard of SQL Server

Maciej Los 9-Aug-13 3:15am

Why do you want to change data using Excel? Please, explain...

bakkupavan 20-Aug-13 14:31pm

Actually, i have a large number of columns. So each time Reading,inserting,updating is burden. So i would like to give this table in an Excel file, and ask the users to make their changes and i will read data from that updated excel file to my database table.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ARUN K P · Answer 1 · 2013-08-12T00:14:00

SQL

SELECT * INTO RECIPENAMES FROM
    openrowset('Microsoft.Jet.OLEDB.4.0','excel 8.0;imex=1;
    database=D:SQL Training\IMPORT\All recipes 13320.xls',[SHEET2$]) T

Note: that Recipenames will be your table name where u gonna insert the data and this code is for 97-2003 excel sheet i.e only for xls files. mention the sheet name. while running the query please close the excel sheet and run.

Karwa_Vivek · Answer 2 · 2013-08-08T20:44:00

Solution 1

Why Dont you Use the IMPORT and EXPORT TOOL provided with SQL SERVER.
The Tool probably you can find in the Drive you have Installed the SQL Server or in
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe.

Its a Data Transformation Service Provided with SQL Server

Posted 8-Aug-13 20:44pm

Karwa_Vivek

Updated 8-Aug-13 20:47pm

v3