CODEWITHSUNDEEP
sqlexcel
Derek Lester
Derek Lester

Reputation: 11

Submit Data in Excel to SQL Table

I need help, I'm trying to give one of our employees an Excel sheet that pulls data from a SQL table, and then allows her to update some fields using Excel back to the SQL Table. I have the Data connection setup so Excel can pull data from SQL correctly, but I'm having no luck getting Excel to send the data back to the SQL table and update the fields. I've seen multiple code examples that seem to do something similar to what I'm looking for but I can't get any traction on it.

Can anyone help me out here?

Upvotes: 1

Views: 2526

Answers (1)

bendataclear
bendataclear

Reputation: 3850

I've tried this a few times and it's never worked out very well, far easier for me and our employees has been to use Access with a linked table that allows data to be written directly back to the server. If possible it might be worth exploring this as it's a completely 'out of the box' solution.

Upvotes: 1

Related Questions