How to synchronize the data changed in Excel to a SQL server

  • Thread starter Thread starter Gen
  • Start date Start date
G

Gen

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA Excel data to SQL Sever table 1
What are the steps to fix damaged MDF files in SQL Server? 0
Importing Excel data with macros to SQL server 1
import Excel worksheet to SQL Server table 7
Excel as front end and SQL Server as back end 0
Push data from Excel to SQL Server 2
Syncthing --- a continuous file synchronization program. 4

Back
Top