PDA

View Full Version : get data from Access database onto Excel



flowergirl
08-12-2011, 04:44 AM
Hi,

I am new to VBA and I need your help on this.

The user enters data into a cell in an Excel worksheet and on pressing ENTER the other cells in that worksheet gets populated with data retrieved from an Access database. Like the user enters the Employee Name, and then the Grade, Designation etc gets populated.

How can I achieve this?

Thanks for your help.

Kenneth Hobs
08-12-2011, 05:09 AM
I would use ADO. See http://www.erlandsendata.no/english/index.php?t=envbadac