Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite
1

I have a table that I want to export from arcmap that has around 1.5 million records. I need to import it into access. Now every time I have tried to export it into a format that access will read, like a csv or dbase, the records become corrupted and instead of displaying there values i they have contents such as "3.186345345345-3".

Does anyone know of a way to export to access that will work perfectly?

Thanks.

share|improve this question
1  
what is the original table format? – U2ros Sep 30 '12 at 21:50
@U2ros It is in a gdb. – Mike Szp. Sep 30 '12 at 21:54
1  
@MikeSzp. Is it an ArcGIS 10 File GDB? Or on SDE? Also, how many columns are you looking at (and how big are those columns)? Unfortunately access itself has a 2GB file size limit that you might need to worry about... – om_henners Sep 30 '12 at 23:23
@om_henners the database has about 50 cloumns, it is arcGIS 10.1 and it is in a GDB right now. If filesize is an issue then I can export it in two peices later, I just can't export at all right now without corruption – Mike Szp. Sep 30 '12 at 23:41

1 Answer

up vote 4 down vote

If you're looking to get your data into an access database you could skip the middle conversion step entirely (or rather have ArcGIS handle it for you) by transferring your data to a personal geodatabase, which in reality is an access database.

From ArcGIS you can use the Create Personal Geodatabase tool to create the access database, and then you should be able to just copy your data across (though I'd export a table to geodatabase and copy the table so you don't waste memory and copy geometries if you don't need them).

Alternately (depending on your version of access) if you already have a database (as .mdb) you don't need to create files to copy them across.

Alternately if you're comfortable with command line utilities OGR supports FileGDB and various other formats including CSV, so you can dump your data out of your geodatabase using ogr2ogr.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.