Use VBA to update Access table or Query from Excel

  • Thread starter Thread starter leungkong
  • Start date Start date
L

leungkong

Can I use VBA to update Access table or Query from Excel?

Thanks in advance
 
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
 
You must log in or register to reply here.

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

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

Back
Top