How to read a SQL Table into Excel change the data and write back into SQL

  • Thread starter Thread starter Belinda
  • Start date Start date
B

Belinda

I want to use Excel as a frontend to maintain a few SQL tables. All I
want to do is read the contents of the SQL Server Table into a Excel
worksheet within Excel now I want to change, add or delete entries and
writeback this data into the SQL Server table.

Please would you be kind enough to share the workbook by emailing me
such a sample workbook or posting the code that can do this.

Thanks
Belinda
 

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

Push data from Excel to SQL Server 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA Excel data to SQL Sever table 1
Importing Excel data with macros to SQL server 1
Excel as front end and SQL Server as back end 0
How to write back a SQL Server table from Excel 3
How to read from a SQL Server table into Excel and use the Excel cell format as in the database 1
how to import an excel table into sql server express? 1

Back
Top