+ 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,518

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

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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

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

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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)

Similar Threads

  1. Importing data from Access to Excel table
    By bigpappi23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2015, 04:44 AM
  2. Importing a partial table from access to excel
    By CAntosh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2015, 03:49 AM
  3. Replies: 2
    Last Post: 12-13-2014, 06:42 PM
  4. Generating an Excel sheet and importing it into Access with VBA triggered in Access
    By JungleJme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2012, 07:43 AM
  5. Importing excel spreadsheet into access table, getting excel row header error
    By ncsthbell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2010, 02:36 PM
  6. VBA: Importing Excel data to Access Table
    By NSTurk725 in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2010, 11:18 AM
  7. Importing data from Access to Excel, but I need to vary the table from Access
    By Liz L. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 09:15 PM

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