Import Multiple Files

[ano1optimist]

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.

[Tom van Stiphout]

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.

[Tom van Stiphout]

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.

[Bradley]

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

[Bradley]

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