Linking Excel data with access database using VBA

[suji]

Hi

I appreciate the support and guidance from all the members of the site in solving the problems…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I have created a database in Access with the columns as Prod id, description, Status, Additional information (large pool of data). Status column have different categories as available, No available, Can be arranged in 30 days & Others.<o></o>
In excel I have a column with product Id, Status and Additional Information…In which sales team will enter their list of products (more than one product at a time) and will click on a command button to execute the function, This function should check for the product id in the access database and retrieve the Status and Additional information in the respective product into the excel columns with Status and addinal Info..<o></o>
<o> </o>
Please help me how to create a VBA code to perform the above task….<o></o>
<o> </o>
<o> </o>
Thank you Once again.<o></o>

 

[SydneyGeek]

Look at this tutorial, especially part 5 (which shows one way to achieve what you want).

Denis

 

[suji]

Hi Denis,

I am sorry i forget to mention that i am using DAO object module to connect with Access.Please guide me if i can accomplish above task using DAO.

Again Thanks a lot for you support...

Suji

 

[SydneyGeek]

Yes you can do it in DAO, but ADO is a more generic technology and allows you to connect to many more database types. DAO is Access-only.
Give the ADO a try, unless you already have some other code that relies on using DAO.

Denis

 

[suji]

Hi Denis,

Thank you for the response.
Yes i am supposed to work on DAO only....Please guide and help me solving my Task.

Thank you Once again
Suji