Thread: How to write back a SQL Server table from Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joe joe is offline
external usenet poster
  
Posts: 62
Default How to write back a SQL Server table from Excel
Belinda

Why not use Access linked tables

In Excel VBA, use ADO to connect to the tables in the SQL Server database. Populate your worksheets (or whateevr) using the recordsets that you create from the DB via the ADO connection object. It isn't hard

Joe
Reply With QuoteReply With Quote