Do you now how I can resolve the fact that when I import a txt file using the Import Specification, that every other record generated to the output Access 2003 table is a completely blank record?

I am developing an Access 2003 application with an MDB type file.
I import a txt file into an Access 2003 table.
After I run the Import Wizard and set up the Import Specification and complete the process,
I open the table that was populated and discover that every other record is completely blank.

Do you know what may have caused this problem and how I may resolve it?
Who is Participating?
mbizupConnect With a Mentor Commented:
I think it was you who posted the question last night about handling null/blank dates imported from your text file.  

Just as a general practice to handle/avoid issues with imported data, rather than importing data directly to Access tables that are visible to your users, I recommend using an intermediate 'staging' table.  

Do a straight (raw) import into this staging table, and then use VBA code and/or queries to get data in the needed format from the staging table into your actual production table(s).
Rey Obrero (Capricorn1)Commented:
first, do a compact and repair then try the import again

if that fails, create a new db, do the import routine..
Jeffrey CoachmanMIS LiasonCommented:
<No Points wanted>

Also note that without us having access to your text file or your import spec (in a sample database), is difficult to see why this blank row is appearing...

A lot of times it may be a carriage return or Line feed...

zimmer9Author Commented:
Does the attached sample file help with your evaluation (includes a heading record plus 1 sample record)?
Jeffrey CoachmanMIS LiasonCommented:
Well I would still need to actual have a sample of your db with the import spec.

But this may all be a moot point because what mbizup posted is the standard way of dealing with these types of situations, please follow up with her.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.