Greetings,

Earlier this year, I imported a Google Earth KML file into Access for California's 515 groundwater basins. The basins are polygons and the KML line defining the polygon sometimes gets as large as 25,000 characters.

I was successful in importing the KML file by telling the wizard to import the lines into a memo field (which can contain up to ~ 65,000 characters). Everything worked well.

Now I have to re-import the KML file because of some spatial changes. But Access keeps truncating the memo field now! Is there someting I need to set in my preferences? My computer crashed since I did this last; maybe I need to reconfigure something.

I've searched all over but can't come up with a solution.

Thanks for any help you can provide!

Jon Mulder
California Department of Water Resources
Red Bluff, CA

Access isn't the right tool, with your trying to store spacial data. KML really isn't meant to be stored in a database anyway since it purpose is for data exchange.

However, my favorite database has an extension that easily deals with spacial data. The following is a blog that describes the process:

http://www.bigfastblog.com/landsliding-int...-with-kml-files

Richard,

Fantastic information! It looks like I'll be adding a few new skills to my GIS skills set.


AvgJoe

I'm glad that you liked it. While I'm really interested in GIS, I'm still waiting for a low cost GIS manipulation software to become available. I'm thinking of something like Autocad that displays data from and saves data directly to the database. But, I'm still waiting.