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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd 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..
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).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.