can not import records with blank fields

Discussion in 'Microsoft Access External Data' started by Guest, Oct 18, 2004.

  1. Guest

    Guest Guest

    I'm trying to import data into an existing table, I've checked the data types
    - these are ok, but it refuses to import records with blank fields;
    importing only those records with every field populated. I am not an
    experienced access user and would appreciate any help with this one.
     
    Guest, Oct 18, 2004
    #1
    1. Advertisements

  2. Guest

    John Nurick Guest

    Hi Sandra,

    One possibility is that the fields in the table are defined as
    "Required".

    Is an XX_ImportErrors table created (where XX is the name of the table
    you're trying to import to? If so, this usually contains clues to what's
    happening.
     
    John Nurick, Oct 18, 2004
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.