Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question