Linking an Excel to an Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I linked an Excel file to build a new Access table (File.GetExternal
Data>Link tables.

I can change the data in the Excel file and the changes take effect in the
table, but Access won't allow me to change the data in the table. Nothing
happens. I get an audible, but no message telling me what is wrong.

How do I resolve this?
 
You must log in or register to reply here.

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

Linking Excel to an Access table 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Record-Locking remains open after closing 0
Turning a 3 column flat file into a "3D" Table 2
#Num Error Linked Excel Table 1
Access to Excel link 2
Changing Links to access databases 1
Data Type Issue in Linked Excel Table 7

Back
Top