I am seeking to create links to excel spreadsheets using DAO and VBA.
The links will be "linked tables."

I have working code to refresh links, but that is not what I want to
do. I also need to create them from.

Can anybody point me in the right direction?

Thank you,
Charles

On Tue, 14 Nov 2006 11:17:15 -0500, ChasW <wrote:

>I am seeking to create links to excel spreadsheets using DAO and VBA.
>The links will be "linked tables."
>
>I have working code to refresh links, but that is not what I want to
>do. I also need to create them from.
>
>Can anybody point me in the right direction?
>
>Thank you,
>Charles

Well I have isolated the problem. It was with some of the sheet names
within the spreadsheet ending with a space and access not allowing the
last character in the field to be a space?

How can I get access to allow the last character in the field to be a
space?

Is there a way to read all of the sheet names from and excel file?