Import text file but need to file blank cells

[YANECKC]

I import a text file that some cells have blanks because there suppressed
repetative data.
Meaning if column a had
boy


bug

car
=======================================
I want someway to fill blanks like
boy
boy
boy
bug
bug
car

I know if I import into excel I could select data edit goto special blanks
enter = in active cell point to cell above and press CTRL + ENTER simultainiously.

The text file is too large for excel so I need that function in Access.
Thank you for your anticipated response.
Yaneckc@aol.com

 

[Corticus]

Hi Yaneckc,

Check this out,

http://support.microsoft.com/default.aspx?scid=kb;en-us;210236

Let us know if it helps, if not, we can try something else. It seems to address your problem well, though, so no point in ellaborating.

HTH,