Macro to export to Excel then import chart back to Access

S

Sue M

Hi there,

Could anyone tell me of a simple macro to export data from
an Access report to Excel. I then want to chart the data
exported and import it back to Access.

May sound crazy, but I know Excel and I know I can simply
chart what I want to there, whereas I'm having major
trouble getting the chart as I want it in Access.

Cheers,

Sue
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Need Help with Macro Security 1
VBA - exporting serial letters to single documents 0
Access 2007 export Macros are deleting sql query 2
export excel chart to image from C# without using interop 0
Access 2003 and excel 0
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart 1
Export Cross tab Query results to excel 8

Top