ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to synchronize the data changed in Excel to a SQL server (https://www.excelbanter.com/excel-programming/400215-how-synchronize-data-changed-excel-sql-server.html)

Gen[_2_]

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