How to use excel vba to specify the path of a link table in access
 

In an access database, I have a link table linking to an external text
file. What i want to do is to specify the path of that text file in
vba code in an excel file. I noticed there is a way to do it in a
module in access vba, but i don't know how to do it in excel vba.

Any help would be greatly appreciated. Thanks a lot.

How to use excel vba to specify the path of a link table in access
 

Show us how you'd do it in Access VBA. I'm betting it's much the same. Post
what you have and we can assist.

Barb Reinhardt

"MCI" wrote:

In an access database, I have a link table linking to an external text
file. What i want to do is to specify the path of that text file in
vba code in an excel file. I noticed there is a way to do it in a
module in access vba, but i don't know how to do it in excel vba.

Any help would be greatly appreciated. Thanks a lot.