Linked Tables Manager - Changing Link to Worksheet

[none]

I have an Excel document that I am linking to from Access. Let's call
it ExcelA. ExcelA has a worksheet, let's call that WorksheetA.

Now, what I would like to do is to change the link from ExcelA
WorksheetA to ExcelB WorksheetB. Currently, when I go through the
Linked Tables Manager and point it to ExcelB, Access is looking for
ExcelB WorksheetA and I get the following message:

"The Microsoft Jet database could not find the object "WorksheetA$".
Make sure the object exists and that you spell its name and the path
name correctly."

How do I fix this?

Thanks!

 

[Guest]

You have to create a new link, and delete the old link.

The linked table manager helps you change a link to point
to the same table in a different database, but it doesn't have
a way to change an existing table to a different table.

(david)

 

[none]

So, you are considering the linked Excel document to be a database?
And the worksheet within the document a table?

 

[Guest]

So, you are considering the linked Excel document to be a database?
And the worksheet within the document a table?

Something like that. It is different in different places, and
depending on which version of Excel you are talking about.

For text files, a database is normally a folder, and a table
is one of the files in that folder.

However, for the purposes of the linked table manager,
there is only the file name, and then everything else. It
will help you change the file name while everthing else
remains the same, and it will help you create new links.

But that's all it does. If you want a more sophisticated
link manager, you can build your own, based on some
of the sample code available on the web.

(david)