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!
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!