Programmatically LINK Excel Tables

[Steve P]

Hi,
I have a project that performs simple comparative analysis on data contained
in two static, archieved excel workbooks.

I want to write some vba that will aid in the linking of the external
tables, so people less familiar with Access can perform the analysis.

I'd like like for the clicking of a command button to prompt the user to
select which excel file they'd like to link (through the file select dialog
box), then link the table to the database....seems pretty simple...i think.
lol.\

Please help.

 

[Ken Snell]

see reply in your repost of this question.