Access Import - skipping line feeds

[scotteh]

Im having a problem importing a text file. Whenever I import it (as a
fixed width, its just a single record, a file name, on each line) many
of the records get grouped together. You can only see them if you make
the height of each table row higher, then you see 3 or 4 lines in a
single record.

The file was created on a mac, then I opened it in Word in XP and
changed the paragraph marks to line feeds (as microsoft recommended to
fix this problem) but the same thing is still happening. I've tried
saving it as a word file, then reopening and saving as a text file with
line feeds. Same problem.

The only other relevant info I can think of is, its a big file. 130,000
records.

Any ideas? Why is access not seeing some of the line feeds (or
paragraph marks. I've tried both, and even tried putting 2 paragraph
marks at the end of each line)?

Thanks!

Scott

 

[Jason Lepack]

Have you tried opening it delimited and specifying the linefeed
character as one of the delimiters?

 

[scotteh]

Hey! That worked!! I didnt specify the linefeed, just chose delimited
and used Tab, since I know there arent any in the file.

Thanks!

Scott

 

[John Nurick]

Hi Scott,

130,000 records shouldn't be a problem.

You say you're importing it as a fixed width file. File names vary in
length: are the records padded out with spaces so that each line is
exactly the same length? If not, it's not a fixed width file: import it
as a delimited file, specifying a delimiter that does not appear in the
filenames. (On a Windows system I'd suggest the pipe character "|", but
if the names are from a Macintosh file system the rules are - or used to
be - different.)