Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update SQL db directly from Excel
http://www.erlandsendata.no/english/...php?t=envbadac
might be a start. -- Regards, Tom Ogilvy "GeorGeorGe" wrote in message ... The goal is this... Have an Excel sheet act as a form for data input and updates and have the cell data attached to SQL for the updating. How would this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update SQL db directly from Excel
Thanks... but I was wondering if there are any data connection options that
allow you to GUI select a data source, and fields of a table that you can specify to be in cells of the worksheet that can be €śeditable€ť so that if the cell is updated it is aware to update the record in the db. That kind of thing or if I am going to have to program it€¦ "Tom Ogilvy" wrote: http://www.erlandsendata.no/english/...php?t=envbadac might be a start. -- Regards, Tom Ogilvy "GeorGeorGe" wrote in message ... The goal is this... Have an Excel sheet act as a form for data input and updates and have the cell data attached to SQL for the updating. How would this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print directly to Excel? | Excel Discussion (Misc queries) | |||
Printing directly to Excel | Excel Worksheet Functions | |||
How to update ms access tables directly from ms excel? | New Users to Excel | |||
How do I go directly to editing a worksheet in excel? | Excel Discussion (Misc queries) | |||
Can I convert directly from excel to RTF? | Excel Discussion (Misc queries) |