It would be great to edit some tables directly in Excel.

[PierreR]

This code by Jacob Mathai found in the code repository and pasted below, seems not to work. The first line does something good. The table opens in Access. The second line opens the Tools menu item in the VBE, and the third line opens the References menu item under Tools.

To open a table in EXCEL, I use this code

DoCmd.OpenTable "tblxxxxx" 
SendKeys "%(TLA)", False ' tools/office links/analyze with Microsoft Excel
SendKeys "Yes", False ' to avoid the confirmation message

Is there a way to edit an Access table directly in Excel? It would be great. Any educational comments about this issue?

 

[aleb]

Mmmm this "code" does nothing but just exports the whole table to excell.
And it works fine for me ... all I did is created a button on a form and "on click" assigned this code.

I am just curious what good would it make to export table to excell and then edit it there? The changes you would make will stay in excell, not in access table ... besides exported file will be created on your locale drive, to crown it all the file which was created the first time you run this code will be overwritten without you knowing next time you will try to run this code.

 

[PierreR]

Think loosely, Pat. It would be convenient to cut and past and drag values across cells. (of course remembering to leave the keys alone) It would not be a good idea for general users; only for personal use.

 

[aleb]

Try this