loading data from an excel to sql DB

Question

I have table data in a sheet of xls. I need to 'update' this data into a table in SQL DB.

Note:

The xls will contain only the columns that will undergo change. (for example if only two columns will undergo changes, then only those two columns for all the records will be present in the xls)
The primary key column will be present in xls for reference.

Please help me in solving this.

SQL being "Microsoft SQL Server", or what database system do you mean?? SQL is just a querying language - not a product.... — marc_s
– marc_s, Commented Dec 1, 2010 at 9:52

John Pickup · Accepted Answer · 2010-12-01 08:42:34Z

2

If this is a one-off load then it is pretty easy to turn the data into SQL statements. Say your sheet has two columns (A & B) then you could put the following formula in column C:

"update tablename set somecol=" & B1 & " where keycol=" & A1

(sorting out quotes for strings, etc as appropriate)

Next just copy the formula down to the bottom, then copy all cells in col C, paste into a text editor and run into your SQL tool.

If you need to hand this over to users or run frequently then there are many, many ways to do this and it really depends on the tools at your disposal (Java, C#, ...)

answered Dec 1, 2010 at 8:42

John Pickup

5,1452 gold badges24 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

loading data from an excel to sql DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related