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

Linking to Excel

P: n/a
RFJ
I've got an access application (XP) where I need to do some final
analysis/layout work in excel.

If I use the Office Links/"Analyze it in Excel" feature I can get the data
across and customize it. But then when the Access database changes and I use
the "Analyze it" feature again, it will either create a new spreadsheet or
will overwrite the existing one and I lose the customisation.

Is there an equivalent of a "Paste Special" that I can use or other fairly
simple process that will accomplish what I'm looking for.

My competence level is probably hovering somewhere around intermediate at
the moment - but I'm a willing learner <G>. So any advice or links to
articles on websites will be appreciated.

TIA

Rob
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.