Use VBA to update Access table or Query from Excel

L

leungkong

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Update Query from Excel VBA module 2
Link, drop link, relink 2
Refresh an Access Query using VBA code in Excel 6
How to export table from outlook into ms access table? 0
Manipulating MS Access records with excel VBA + ADO 7
How pass credentials to Access from Excel (for onward use) 2
Access #Error & Excel Pivot 0

Top