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

Live Updating Excel - Access Links

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.