How do I choose fields from external mdb & xls to do comparison

[cowboy]

I want my user to be able to compare a field "A" in an external access database "1" with a field "B" in an excel spreadsheet "2" based on a field "C". I would like the user to be able to choose all fields and specific database and excel sheets. How should I go about doing this?



I can write all the code to do the actual comparison I just need to figure out the best way to let the user choose the database -> table -> field for me to do the comparisons on.

Thanks for help.

[NTC]

hmmm...well an sql statement, implemented via vb, can call variable data from a form....you know your basic & Forms!SomeForm.textboxname & in the sql statement itself. so that part is more or less straightforward...

but how do you know & establish the universe of files/folders & field names from which the user can select? rhetorically speaking. seems pretty tough to do....