Querying a DB from a VB6 form

Hi guys,

I'm trying yo develop my first application and need your help here:
On one form (Form1) I have a txtbox (txtsearch) and a button (CmdSearch), when the user hit the search button I want the program to look up the name(s) associated to the code entered in txtsearch and display it/them in a message box....

For the data source I have the choice between 2 files:

1 excel spreadsheet: 3 columns: 'Code' - 'City' - 'Country'
1 access 2k DB: same fields

Thanks in advance,

Tom:confused:

read the database tutorial (#2 i think) on vbworld.com... it teaches you that exact example, it uses SQL (structured query language) to search a flexgrid control and get only what you want out of it.

Thanks for the tip :)

no problem... just learning databases myself