+ Reply to Thread
Results 1 to 5 of 5

importing an excel table to an access db, getting importerrors

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,255

    importing an excel table to an access db, getting importerrors

    so i get the following when i do a clean import of an excel file:

    Please Login or Register  to view this content.
    in the first example, does that mean it imported the row but had an issue with the zipcode and did not put in the value in that field? (i think not cause i checked those rows and the zipcodes are correct)

    thoughts?

  2. #2
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,255

    Re: importing an excel table to an access db, getting importerrors

    any help for an access vba newbie?

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,135

    Re: importing an excel table to an access db, getting importerrors

    What's different about the zip codes in those rows? Do you perhaps have a mix of 5 digit and longer zip codes?
    Rory
    Days when we raged, we flew off the page
    Such damage was done

  4. #4
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,255

    Re: importing an excel table to an access db, getting importerrors

    thanks roray for replying,

    nope, they are all 5 digit zipcodes, i do have some blanks but they are all accounted for. my table in excel is 383 rows and my table in access is 383. it appears as if the import was fully done.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,135

    Re: importing an excel table to an access db, getting importerrors

    It will import the row, it just had an issue with that particular field.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1