Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Link multiple excel files at one time

1 view
Skip to first unread message

JE

unread,
Jan 6, 2010, 8:40:01 PM1/6/10
to
I have about 60 excel files that I want to link in an Access database. Other
than manually link each file individually, is it possible to link all at one
time?

Many thanks!

John W. Vinson

unread,
Jan 6, 2010, 9:55:17 PM1/6/10
to

How can your program determine which excel files should be linked? All of the
.xls files in a folder, or what?

You can use VBA code with the TransferSpreadsheet method to create a link from
scratch - see the VBA help for the method.
--

John W. Vinson [MVP]

JE

unread,
Jan 6, 2010, 11:16:01 PM1/6/10
to
The database is not yet created. In a previous db which was similar, I
manually linked each Excel file in the database and then used the tables in
subsequent queries. I should add that I do write in vb as I am still
learning.

Any help is most appreciated.

"John W. Vinson" wrote:

> On Wed, 6 Jan 2010 17:40:01 -0800, JE <J...@discussions.microsoft.com> wrote:
>
> >I have about 60 excel files that I want to link in an Access database. Other
> >than manually link each file individually, is it possible to link all at one
> >time?
> >
> >Many thanks!
>
> How can your program determine which excel files should be linked? All of the

> ..xls files in a folder, or what?

>
> You can use VBA code with the TransferSpreadsheet method to create a link from
> scratch - see the VBA help for the method.
> --
>
> John W. Vinson [MVP]

> .
>

John W. Vinson

unread,
Jan 6, 2010, 11:52:18 PM1/6/10
to
On Wed, 6 Jan 2010 20:16:01 -0800, JE <J...@discussions.microsoft.com> wrote:

>The database is not yet created. In a previous db which was similar, I
>manually linked each Excel file in the database and then used the tables in
>subsequent queries. I should add that I do write in vb as I am still
>learning.

So...? Are you ok with this or do you need more info?

JE

unread,
Jan 7, 2010, 7:44:01 AM1/7/10
to
I will reference your suggestion on VBA code with the TransferSpreadsheet
method, however is there any other option other than VBA? Thank you.

"John W. Vinson" wrote:

> .
>

JE

unread,
Jan 7, 2010, 8:11:01 AM1/7/10
to
John, I have referenced information regarding TransferSpreadsheet and this
may work. Thanks for the assistance.
0 new messages