Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating a SQL Dbase using values in specific Excel cells
An ADP project in Access is a front end to an SQL Server database. Depending
on its configuration, any changes in the ADP are reflected into the underlying SQL Server Database automatically. I am not sure why you are reflecting changes in the worksheet to the ADP rather than to the SQL Server database directly. {If you did, the ADP will update automatically}. As I understand it, you are using the Excel GUI to update the table: The SQL statement may not be straightforward; e.g if you change a value that is a KEY in the underlying table, the SQL is 'INSERT INTO ...' but if you change values that are not KEYS in the underlying table. the SQL is 'UPDATE {table name} {fieldlist} Values{...} WHERE {conditions to identify target row(s)}'. The other question you want to ponder is whether you want to reflect the changes as they happen or whether you want to reflect the changes in batch, perhaps when a button is clicked or when the workbook is saved. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to delete specific values in cells | New Users to Excel | |||
assign values to specific cells in an excel sheet through text file | Excel Discussion (Misc queries) | |||
How to Export datas from Excel cells to another excel/dbase file | Excel Discussion (Misc queries) | |||
Count cells with specific values in the cells next to them? | Excel Worksheet Functions | |||
Returning Values from specific cells in Excel using C# | Excel Programming |