can not import records with blank fields

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

John Nurick

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
Import from Excel with some bad dates causes no records to import 1
Import errors w/dates 3
import ignores the text format in table's field 1
Importing Text Fields in Excel 2
Text import not WYSIWYG 1
import related records 4
Importing to Access from Excel adds tons of blank records 4

Top