469,347 Members | 19,798 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Live Updating Excel - Access Links

Hi,
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.

C2=(C1-A2+B2)

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
various
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,
Mark
Nov 13 '05 #1
0 1298

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.