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
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
