Click here to Skip to main content
15,850,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Have a good day.
Please help me to import data from 1 excel file to ms Access Database. I'm learning

Thank you very much!

ex :
- Excel fields : id , name, address
- Access table : id(P key) ,name, address
Updated 21-Nov-10 21:08pm

1 solution

Please visit following link:

Export data from Excel to Access (ADO) using VBA in Microsoft Excel[^]

Please do let me know, if you have any doubt.

Please provide "Vote":thumbsup: if this would be helpful, and make "Accept Answer" if this would be correct answer.:rose:

Share this answer
Dalek Dave 22-Nov-10 5:44am    
Good Call.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900