Exportin report data to ms access.

[Macho123]

Hi All,

I am using crystal reports Xi and the user needs the output of the report to be an access file.

Righ now what I am doing is first transfer the report output to a text file and then importing that text file into access. This is a weekly process and I want to acutomate it so the output of the report automatically be saved as an access file.

Is there a way to do this?

We are using business objects infoview to schedule the reports.

Thanks...

 

[IdoMillet]

If the table already exists, the process would fail. Consider a 3rd-party tool as a solution (for a list of such tools, see

http://www.kenhamady.com/bookmarks.html).

Here is a description of how my Visual CUT software allows you to do this:

http://www.milletsoftware.com/Download/Visual CUT ODBC Export Functionality.pdf

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Macho123]

Thanks for the reply. But we are not using those tools at my work palce.

Thanks...