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

Export from Access to Excel

P: 41
I have been attempting to export data from an Access 2003 DB to display as a chart in Excel. For half of the data the charts are displayed normally but for others they pop up for only a second then it says I have an error in my method that turns the data into the chart format. Is there a built in command to hold the chart up on the screen in VBA? Thanks
-Todd
Feb 26 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
I'm afraid you'll have to solve the error....

I would start looking to the difference in the data selected for correct and wrong charts.
Often erroneous data (Null's or text instead of numbers) is causing this havoc.
Another option might be to use excel and try the problem selections from there to link.

Nic;o)
Feb 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.