Results 1 to 3 of 3
  1. #1
    JonMulder is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    24

    Import KML File Into Access

    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.

    Thanks for any help you can provide!

    Jon Mulder
    California Department of Water Resources


    Red Bluff, CA

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You could do a compact and repair.
    Did you delete the originally imported KML file? Did the file size change that much?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import txt file into Access Table
    By redbull in forum Import/Export Data
    Replies: 3
    Last Post: 05-02-2012, 09:32 AM
  2. Import Excel file to Access
    By emmett in forum Import/Export Data
    Replies: 3
    Last Post: 04-06-2012, 05:27 AM
  3. Replies: 2
    Last Post: 01-26-2012, 12:19 PM
  4. Replies: 5
    Last Post: 10-28-2011, 12:20 PM
  5. How to import a .dta file into Access 2010?
    By Louie in forum Import/Export Data
    Replies: 4
    Last Post: 07-26-2011, 06:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums