Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to update Access table or Query from Excel
Can I use VBA to update Access table or Query from Excel?
Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to update Access table or Query from Excel
Hi Leungkong,
Can I use VBA to update Access table or Query from Excel? Of course, using ADO or DAO. See: http://www.erlandsendata.no/english/...badacexportado Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to update Access table or Query from Excel
Hi Jan,
Thanks. I think ADO is what I want. But I am not only want to export from excel to access. I want to edit some data in access table. For example, Access has a table "ProductList" I want to use Excel to call the product by "ProductCode" field. After I update the "UnitPrice" via excel to access. Can I use ADO to do it? If yes, could you please advice me some book or link? Thank you very much. Kind Regards, Kong "Jan Karel Pieterse" wrote: Hi Leungkong, Can I use VBA to update Access table or Query from Excel? Of course, using ADO or DAO. See: http://www.erlandsendata.no/english/...badacexportado Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to update Access table or Query from Excel
Hi Leungkong,
For example, Access has a table "ProductList" I want to use Excel to call the product by "ProductCode" field. After I update the "UnitPrice" via excel to access. Can I use ADO to do it? If yes, could you please advice me some book or link? Thank you very much. The information is in the same link I gave previously. There is a microsoft press book called "Programming ADO" by Sceppa which is quite good. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update table in access from excel | Excel Programming | |||
Update Access Query save and close through Excel VBA | Excel Programming | |||
How access/query/update Excel using VC? | Excel Programming | |||
update Access Table in Excel | Excel Programming | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |