Help Exporting data to Excel

[ajorge]

I have a query that gives me the sum of five fields. I need to export that information to an excel sheet. I already the excel sheet set up to generate a Pie chart wiht the data. I just need to populate the fields. Can some please help. Thank you in advance

Alexander Jorge
City of Miami
Information System Analyst

 

[batteam]

Try thinking about IMPORTING your data starting from Excel, using Excel's query wizard. It does work very well with a little tweaking and practice. And its easier than trying to export data from Access into Excel using Excel application programing in your code.

You can do this from Excel's toolbar: |Data|Get External Data|New Database Query|. Follow the wizard steps. Once you've saved your query, in the future you can then use |...|Run Saved Query|. Hope this helps. Good luck