By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

Linking Table & Excel during Runtime

P: 26
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
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
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

P: 26
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

P: 8
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.