| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update database from ODBC query (or another method)
I am able to to pull data into Excel via ODBC query.
My question is: can I edit it? I am able to edit the data via Access and linking the table but I cannot see a way of doing this in Excel. Any suggestions? Thanks Richard |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update database from ODBC query (or another method)
Rather than using a SELECT SQL statement you need to use an UPDATE one - the
link here should help: http://technet.microsoft.com/en-us/l.../ms177523.aspx Don't be put off by how complex it looks - the examples at the bottom should help. As a rough idea, if you have a table with two fields, you can update field one based on the value of field 2 with a statement as follows: UPDATE table1 SET field1 = 'New field 1 value' WHERE field2 = 'field 2 criterion' Sam "Richard Edwards" wrote: I am able to to pull data into Excel via ODBC query. My question is: can I edit it? I am able to edit the data via Access and linking the table but I cannot see a way of doing this in Excel. Any suggestions? Thanks Richard |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update database from ODBC query (or another method)
Ahhhh...
Can this be done within MS Query by updating the SQL? "Sam Wilson" wrote in message ... Rather than using a SELECT SQL statement you need to use an UPDATE one - the link here should help: http://technet.microsoft.com/en-us/l.../ms177523.aspx Don't be put off by how complex it looks - the examples at the bottom should help. As a rough idea, if you have a table with two fields, you can update field one based on the value of field 2 with a statement as follows: UPDATE table1 SET field1 = 'New field 1 value' WHERE field2 = 'field 2 criterion' Sam "Richard Edwards" wrote: I am able to to pull data into Excel via ODBC query. My question is: can I edit it? I am able to edit the data via Access and linking the table but I cannot see a way of doing this in Excel. Any suggestions? Thanks Richard |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update database from ODBC query (or another method)
Not that I know of - I don't think MSQuery is that clever.
"Richard Edwards" wrote: Ahhhh... Can this be done within MS Query by updating the SQL? "Sam Wilson" wrote in message ... Rather than using a SELECT SQL statement you need to use an UPDATE one - the link here should help: http://technet.microsoft.com/en-us/l.../ms177523.aspx Don't be put off by how complex it looks - the examples at the bottom should help. As a rough idea, if you have a table with two fields, you can update field one based on the value of field 2 with a statement as follows: UPDATE table1 SET field1 = 'New field 1 value' WHERE field2 = 'field 2 criterion' Sam "Richard Edwards" wrote: I am able to to pull data into Excel via ODBC query. My question is: can I edit it? I am able to edit the data via Access and linking the table but I cannot see a way of doing this in Excel. Any suggestions? Thanks Richard |
|
#5
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update database from ODBC query (or another method)
ok. Thanks very much.
"Sam Wilson" wrote in message ... Not that I know of - I don't think MSQuery is that clever. "Richard Edwards" wrote: Ahhhh... Can this be done within MS Query by updating the SQL? "Sam Wilson" wrote in message ... Rather than using a SELECT SQL statement you need to use an UPDATE one - the link here should help: http://technet.microsoft.com/en-us/l.../ms177523.aspx Don't be put off by how complex it looks - the examples at the bottom should help. As a rough idea, if you have a table with two fields, you can update field one based on the value of field 2 with a statement as follows: UPDATE table1 SET field1 = 'New field 1 value' WHERE field2 = 'field 2 criterion' Sam "Richard Edwards" wrote: I am able to to pull data into Excel via ODBC query. My question is: can I edit it? I am able to edit the data via Access and linking the table but I cannot see a way of doing this in Excel. Any suggestions? Thanks Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update database from ODBC query | Excel Discussion (Misc queries) | |||
| ODBC database query | Excel Discussion (Misc queries) | |||
| ODBC Drivers to a SQL database | Excel Discussion (Misc queries) | |||
| Multiple ODBC Database lik in one MSQUERY query | Excel Discussion (Misc queries) | |||
| Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
Hybrid Mode
