Hello,

I am attempting to save an excel file as a CVS file in order to bul
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 blan
(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 hav
a comma between Field2 and Field3. The rest of the rows only has
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?

Thank

--
Napoleo
-----------------------------------------------------------------------
Napoleon's Profile: http://www.excelforum.com/member.php...fo&userid=3700
View this thread: http://www.excelforum.com/showthread.php?threadid=56727