Export into an MS Access Table for GIS Geocoding

[socalvelo]

Using CR 9.0

I use a CR that generates crime data addresses to plot onto a map using ArcView GIS.

ArcView imports this type of info from database formats but not Excel. I export my report in Excel Format. I then open MS Access and Import from Excel. I would like to take out one step and export directly to an Access table. I could probaby set Access to auto link to the Excel file. But I was wondering if anyone has come accross a method to export from Crystal Reports to Access (.mdb) table.

Ed

 

[IdoMillet]

Just export to ODBC. Set up an ODBC DSN for your Microsoft Access database and the ODBC export dialog would allow you to select that ODBC DSN and specify a table name to be created by the export.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Keep in mind that you cannot append to an existing Access table though, only write to new tables.

Curious why you don't just use Access?

And yes, you can select New Table and select Link and point to your Excel table, then use the Excel linked table in Access as the source for the Arcview import.

Given that you'll haev to write to new tables, it would be simpler to overwrite the Excel table and link to it, and simpler still to have a query or table in Access that generates the labels real time and use that as your source for Arcview.

-k

 

[IdoMillet]

S.V. is right about the ODBC export limitation. If you need to automate a repeating process whereby the information is appended to (or replaces) an existing ODBC table or if you need to append the export to an existing spreadsheet, there is at least one 3rd-party Report Manager (see list at:

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

that can do this.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[socalvelo]

Thank you for the replys. I will try the ODBC option Access/Excel linking. The reason I don't do the whole process with only Access is that I have to clean up the formatting on the street addresses with CR plus there is some filtering of dates and other things that is easier for me to do in CR.