Linked Table Manager - Query using an Excel file

D

dhstein

I have an Excel file that I use to update quantities. This used to work, but
now it doesn't. The error I get on the update query is UpdateQuantity$ is
not a valid name. Apparently linked table manager thinks my sheet name has a
"$" at the end. Linked table manager shows UpdateQuantity (U:\Update
Quantity.xlsx\UpdateQuantity$) Is there a way to fix this, or do I have to
delete the table link and recreate it? Thanks for any help on this.
 
A

Arvin Meyer MVP

I would delete the link and recreate it. If that doesn't solve the problem
you may have some corruption in your database itself. Then I would delete
the link, compact the database, and recreate the link.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Excel freezing after sharing document by Email 0
Append Crosstab Query to Existing Table 0
Embedded Excel into Word with Tables 0
Adding data to MS Access from csv file 0
Linked Excel File won't update 1
Linked Table Manager in ACCESS 4
Excel - Wich Function should I use? 1

Top