Importing one row takes the place of two
 

I've written a program that takes the results from a web form and emails the
customer an attached tab delimited text file that they can then import into
Excel.

Only problem is that the single row import process claims two rows each
time. So records are on lines 1,3,5,7,9 etc. This was not previous behavior
for Excel.

I've tried sending line feed or return characters at the end of the file but
they make no difference whatsoever.

How do I get a single row import from text to claim a single row?

--
Rick Mason

Importing one row takes the place of two
 

I'd guess that your text file has a couple of new line characters (instead of
just one) at the end of each line.

You may want to inspect the text file in some hex editor.

RickM wrote:

I've written a program that takes the results from a web form and emails the
customer an attached tab delimited text file that they can then import into
Excel.

Only problem is that the single row import process claims two rows each
time. So records are on lines 1,3,5,7,9 etc. This was not previous behavior
for Excel.

I've tried sending line feed or return characters at the end of the file but
they make no difference whatsoever.

How do I get a single row import from text to claim a single row?

--
Rick Mason

--

Dave Peterson