Opening a csv file

[Harrold]

I have a comma seperated file with over 64,000 lines in it. When I open this file in Filemaker Pro 8 I only have a little more then 32,000 records.

To prove that my text file has over 64,000 lines I open the file in Excel and it works like a dream I have all my records in Excel. (By the way that's how I get the records into FM. I import it from Excel) Any ideas.

[beverly]

Is it truely "comma-separated"? FMP likes to have double-quotes around the values, not just a comma separating them.

[Harrold]

I tried by manually replacing commas with double quotation marks. Yet I have the same problem

[Lee Smith]

Not instead of, but in combination with.

"data field1", "data field2", "data field3", "etc",

HTH

Lee