472,123 Members | 1,488 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,123 software developers and data experts.

Live Updating Excel - Access Links

Can anyone point me in the right direction to learn how to
get real time updates in an Access form from an Excel spreadsheet?

I'm trying to link the following formula which exists in an Excel
spreadsheet and works perfectly to an Access form. It's just like
a checkbook register.


I would drag this formula down for a coupel of hundred records
( or "rows"), which leaves me initially with column C full of zeros and
that's OK.

C is the running sum column. The A column is any number
and the B column is any number.
So I look "up" at my last running sum, (C2 looks "up" at C1),
deduct any numbers from A2 and add any number from B2.
So on and so forth as I add numbers into columns A and B.
When I use File / Get External Data / Link Tables it "almost" works,
but there's a lot of fussing around with it (bringing the spreadsheet to the
forefront and then bringing the form to the forefront, etc.), and in the
end, I get a
"spreadsheet is full" error and the whole thing comes a halt. I've tried
codes, etc. even from the MS site and they don't work very well. This just
isn't something Access does well I suppose.
Thanks for any help, hints or tips.

Thank you,
Nov 13 '05 #1
0 1369

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by phil03 | last post: by
1 post views Thread by ChasW | last post: by
5 posts views Thread by aaron.m.johnson | last post: by
12 posts views Thread by slinky | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.