Excel and Access

  • Thread starter Thread starter RSMan
  • Start date Start date
R

RSMan

Hi All,
I admit I am a complete novice on this aspect of using
Excel. My requirement is as follows.

I have an Access Database called nt1.mdb on drive D: in
which there is one table (Table1) of data, indexed on
column1

I wish to connect to this database and search the contents
of Table1 for a value in column1 that has been entered
into an Excel userform. The values of the other columns
in Table1 should be returned if the value is found.

How do I connect to the mdb, do the search and read the
resulting values from the table?

Any help gratefully received.
Cheers
 
Back
Top