Print Page | Close Window

Export CR to MS Access

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17849
Printed Date: 20 Apr 2025 at 10:53pm


Topic: Export CR to MS Access
Posted By: eawhitcomb
Subject: Export CR to MS Access
Date Posted: 26 Oct 2012 at 4:28am

I have inherited 2 reports that are run manually each month in CR 2008.  The current process is to export the results to Excel and then run a macro in MS Access to load the data there. I see that I can export my CR results directly to MS Access (which would be preferable to me) but where I can't get a clear answer is if I can append to an existing table every month or not.  Any ideas?

Thanks!
Elizabeth


Replies:
Posted By: CircleD
Date Posted: 29 Oct 2012 at 12:57am
Make a copy of the report for a just in case something goes wrong.Then open the report in "Design" and hit the "Export"button. Make your choice of where you want the report to export to and save it. If MS Access is one of the choices (I don't have Crystal on this computer so I can't check it to make sure) then you should be good to go.

Posted By: hilfy
Date Posted: 29 Oct 2012 at 6:04am
You also need to make sure that you are able to connect to the destination database through ODBC - so you'll need to set up an ODBC System (not User!) DSN for it.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window