That's way Excel exports data, in blocks of 16 rows. Can't find MS KB
article at the moment, but this is by design.
Either make sure there is a least 1 value (even a "" or 0) in each 16 row
block, or save your own data.

NickHK

"Napoleon" wrote in
message ...

Hello,

I am attempting to save an excel file as a CVS file in order to bulk
insert it into SQL Server (I know DTS can import Excel files directly,
but I need to use Bulk Insert).

The problem is that the all of the values in the final field is blank
(I did not create the file). For example:
Field1 Field2 Field3
1 2
1 2
1 2

The problem is when I save it as a CVS file only the first 16 rows have
a comma between Field2 and Field3. The rest of the rows only has a
comma after Field1. For example:
Field1,Field2,Field3
1,2,
1,2,
1,2
1,2

Does anyone know if there is a way to fix this?

Thanks


--
Napoleon
------------------------------------------------------------------------
Napoleon's Profile:
http://www.excelforum.com/member.php...o&userid=37002
View this thread: http://www.excelforum.com/showthread...hreadid=567279