I have user table in my DB. I have 1 excel sheet having list of some users (not all) with changes. How can I Update the values given in excel sheet to my user table? is it possible with import data option?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I only learned this in the past year. You can query an excel sheet as if it's a table. As long as your keys are also in excel you can join the excel sheet to the user table.
You can have a look at this Microsoft Article that discusses options for importing from Excel to SQL Server.
If you are interested, I have built an Excel to SQL Server tool where end users update their data in Excel sheets on the intranet and the application will take care of parsing the Excel spreadsheet and export the data to a SQL Server table.
I'am currently looking for feedback so I give away licenses (two end users) to people who give feedback on the product.
The tool is called SQL Spreads: www.sqlspreads.com
The workaround is: