467,879 Members | 1,233 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,879 developers. It's quick & easy.

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

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 http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
  • viewed: 8263

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Phil Rutter | last post: by
4 posts views Thread by Neil Ginsberg | last post: by
3 posts views Thread by Parasyke | last post: by
7 posts views Thread by franc sutherland | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.