By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,896 Members | 1,562 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,896 IT Pros & Developers. It's quick & easy.

Dynamically create linked tables (based on Excel files) and prompt user for files to be linked...

P: n/a
I am using Excel/Access 2000 and have two large Excel files (25,000 rows
each) that I wish to create linked tables in Access rather than
importing into Access. The two source Excel files change frequently, so
I want to:

A) prompt the user, using a custom form, for the specific Excel files to
be linked;
B) create the links dynamically;
C) insert the linked tables into a select query grid and include the SQL
statement in the VBA procedure.

The custom form could simply act as an Open dialog with a path to the
first file, then clicking OK, and then a linked table would be created.
A second appearance, perhaps of the same custom form, would prompt for
the second file to be linked, and then the second linked table would be
created. Or, a single dialog with two list boxes could be used to
identify the files to be linked.

I'd like to suppress the Link Spreadsheet Wizard dialog and accept the
default settings. After the linked tables are created, then I would like
to create a query based on the files selected. A report would be based
on the newly created query conditions.

Any help would be appreciated

Thanks in advance, Chris

*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.