How to populate an SQL table with data from Excel?

B

B

B_M2018-05-29 15:40:34

SQL

B_M, 2018-05-29 15:40:34

How to populate an SQL table with data from Excel?

There is an Excel file with two columns, CODE and VALUE. And there is a table in the MS SQL database containing, among others, columns CODE and VALUE. It is necessary for each CODE from Excel to find the corresponding CODE in the SQL table, and if it is found, write the corresponding VALUE from the Excel file to SQL. Is it possible to solve this problem with regular Excel tools? If so, how? If not, what other options are there?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

Similar questions

R

Roman Tuzov2021-03-22 23:47:34

How to count from 0 and beyond? 3Reply

J

JayDeeZz2018-04-04 17:29:34

Forming a request? 1Reply

A

Alex Serov2015-11-28 02:09:05

How to build a table in SQL that describes a binary tree by a string that describes it using brackets? 2Reply

A

AcidBat2015-11-28 18:44:51

SQL doesn't want to accept any numbers other than one. What is the problem? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question