May 17 2012, 10:27 PM
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!
California Department of Water Resources
Red Bluff, CA
May 17 2012, 10:52 PM
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
May 18 2012, 09:07 AM
Fantastic information! It looks like I'll be adding a few new skills to my GIS skills set.
May 21 2012, 09:36 AM
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.