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

Have you tried opening it delimited and specifying the linefeed
character as one of the delimiters?
scotteh wrote:
> 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

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




Jason Lepack wrote:
> Have you tried opening it delimited and specifying the linefeed
> character as one of the delimiters?

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.)

On 19 Jan 2007 08:26:40 -0800, "scotteh" <(E-Mail Removed)> wrote:

>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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.