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?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question