link data from access to excel

G

Guest

I linked a table from excel into access. I should be able to add, delete
records from access and have them link to excel but it does not let me add
new records. I can however add new records from excel and update access. It
is suppose to let me go from access, add new records and show up in excel.
Any suggestions?
 
G

Guest

It works if you were able to use Office 2000 or 2002, but not in later
versions.
However even then if you update data in Excel via Access I found I lost RTF
formatting....
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import new data and replace old data in Access table. 4
I have link an excel table to my access table and having problem 1
Import Updated Data from and Excel to Access 2
How do i update Access Table using data from Excel spreadsheet 3
Export Data from Excel into Access 5
Access to Excel filtered 3
Link From Access To Excel 3

Top