468,284 Members | 1,505 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,284 developers. It's quick & easy.

Linking Table & Excel during Runtime

Can I link a table and a excel file during runtime?

Or is there a way to refresh the table which is linked to a table, to pick up the latest changes in the excel file and to update the linked table?

With the update query the first time changes in the excel is reflecting the linked table.
The linked table I had created from the file menu.

There is a need for frequent updates.

Pls assist.
Thanks & Regards,
Sheereen.
Sep 27 '06 #1
3 2593
PEB
1,418 Expert 1GB
Hi,

This is possible to do links in runtime it's with docmd.Transferspreadsheet command!

Also it's possible to refresh you Excel! Form Records/Refresh!

But remember you can't work as multiuser with Excel!

if you aren't alone on this file u have to do some pb with it!

:)
Sep 27 '06 #2
Hi,

This is possible to do links in runtime it's with docmd.Transferspreadsheet command!

Also it's possible to refresh you Excel! Form Records/Refresh!

But remember you can't work as multiuser with Excel!

if you aren't alone on this file u have to do some pb with it!

:)
Hi,

Thank You..

Rgds,
Ruth.
Sep 28 '06 #3
Sorry to jump in here, but I have an added question.

I having the same sort of issue, however I will have more then one person the Acess DB. How can I make it so i update/change the excel table (that is linked to the access form) and save the excel table, while other are in the DB form? Any help on this would be great thanks alot
Apr 11 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Atul Godbole | last post: by
reply views Thread by huseyinakturk | last post: by
2 posts views Thread by Michael Kalika | last post: by
7 posts views Thread by franc sutherland | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.