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

Import Multiple Files

P: n/a
I'm trying to import multiple files that contain the following
directory structure:

c:\main\subfolder1\sample.mdb
c:\main\subfolder2\sample.mdb
c:\main\subfolder3\sample.mdb

where the subfolder names are not consistent although the actual
sample databases are the same format.

How can this be accomplished. I'm able to select all the folders but
as soon as click the open button, it puts me in either the first or
last subfolder.

Thanks for your help.
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 24 May 2004 19:51:31 -0700, an**********@aol.com (ano1optimist)
wrote:

Write a bit of VBA code.
What do you mean 'names are not consistent'? If they are predictable
the code can figure it out; if not, perhaps you can do a multi-select
and work with the File/Open dialog results to access the various
subfolders.

-Tom.

I'm trying to import multiple files that contain the following
directory structure:

c:\main\subfolder1\sample.mdb
c:\main\subfolder2\sample.mdb
c:\main\subfolder3\sample.mdb

where the subfolder names are not consistent although the actual
sample databases are the same format.

How can this be accomplished. I'm able to select all the folders but
as soon as click the open button, it puts me in either the first or
last subfolder.

Thanks for your help.


Nov 13 '05 #2

P: n/a
On 24 May 2004 19:51:31 -0700, an**********@aol.com (ano1optimist)
wrote:

Write a bit of VBA code.
What do you mean 'names are not consistent'? If they are predictable
the code can figure it out; if not, perhaps you can do a multi-select
and work with the File/Open dialog results to access the various
subfolders.

-Tom.

I'm trying to import multiple files that contain the following
directory structure:

c:\main\subfolder1\sample.mdb
c:\main\subfolder2\sample.mdb
c:\main\subfolder3\sample.mdb

where the subfolder names are not consistent although the actual
sample databases are the same format.

How can this be accomplished. I'm able to select all the folders but
as soon as click the open button, it puts me in either the first or
last subfolder.

Thanks for your help.


Nov 13 '05 #3

P: n/a
ano1optimist wrote:
I'm trying to import multiple files that contain the following
directory structure:

c:\main\subfolder1\sample.mdb
c:\main\subfolder2\sample.mdb
c:\main\subfolder3\sample.mdb

where the subfolder names are not consistent although the actual
sample databases are the same format.

How can this be accomplished. I'm able to select all the folders but
as soon as click the open button, it puts me in either the first or
last subfolder.

Thanks for your help.


Select the root folder,

Use the Dir() function to go through each folder one at a time..

Hope that helps.
--
regards,

Bradley
Nov 13 '05 #4

P: n/a
ano1optimist wrote:
I'm trying to import multiple files that contain the following
directory structure:

c:\main\subfolder1\sample.mdb
c:\main\subfolder2\sample.mdb
c:\main\subfolder3\sample.mdb

where the subfolder names are not consistent although the actual
sample databases are the same format.

How can this be accomplished. I'm able to select all the folders but
as soon as click the open button, it puts me in either the first or
last subfolder.

Thanks for your help.


Select the root folder,

Use the Dir() function to go through each folder one at a time..

Hope that helps.
--
regards,

Bradley
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.