| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write data back from a form to sheet | Excel Discussion (Misc queries) | |||
| How can I write 3/5 in a cell and have it look like 03-May back? | Excel Discussion (Misc queries) | |||
| connecting to back end server | Excel Discussion (Misc queries) | |||
| SQL Server UPDATE Database from Excel Table | Links and Linking in Excel | |||
| Is it possible write a self-defined function in excel that connect to SQL server to get data? | Excel Programming | |||
Threaded Mode
