asked on

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?

Rey Obrero (Capricorn1)

first, do a compact and repair then try the import again

if that fails, create a new db, do the import routine..

ASKER CERTIFIED SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

<No Points wanted>

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

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

JeffCoachman

zimmer9

ASKER

Does the attached sample file help with your evaluation (includes a heading record plus 1 sample record)?
TIMNYCashBreaks.txt

Jeffrey Coachman

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, ...so please follow up with her.

;-)

JeffCoachman