can not import records with blank fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type Conversion Failure importing number as text 1
Importing data from Sharepoint 2007 to Access 2003 0
Importing XML Data in Access 2003 1
Import from Excel with some bad dates causes no records to import 1
import ignores the text format in table's field 1
Text import not WYSIWYG 1
Error importing to Access - file was not imported 1
Import errors importing Text into existing table, header vs no hea 3

Back
Top