How to synchronize the data changed in Excel to a SQL server
Hey all, i received a project that asks me to read the data from a SQL
server to EXCEL 2003, do some modifications, and update the changes on the SQL server as well. I found a stupid way to do it as following: import the data to Excel, do changes, open it with MS Access, then Synchronize. I found this is a bit stupid, but it works, and also this is the only way i would come up with. I am just wondering is there a better way to do it? Thanks guys for the help, I am looking forward for your solutions :D |
All times are GMT +1. The time now is 08:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com