Exporting file in CSV format

S

Steve Breen

Currently I have a customer that wants me to send them a
in file in csv format with cetain column headings.

After we save this file it is sent via ftp to a customer
and the import this into a database.

As you can see the 1st 15 lines work well. Empty spaces
are seperated by a comma. After aprox 15 spaces the comma
seperation stops. Not sure why? Can anyone advise.

Carrier,BolNbr,ShipmentNbr,ProNumber,ApptDate,DeliveryDate,
ContactDate,ContactName,Comment
10131,M60506,,,,,,,
10131,M61070,,,,,,,
10131,M61234,,,,,,,
10131,M61320,,,,,,,
10131,M61476,,,,,,,
10131,M61676,,,,,,,
10131,M61905,,,,,,,
10131,M61911,,,,,,,
10131,M61947,,,,,,,
10131,M62019,,,,,,,
10131,M62548,,,,,,,
10131,M62571,,,,,,,
10131,M62879,,,,,,,
10131,M63019,,,,,,,
10131,M63166,,,,,,,
10131,M63168
10131,M63656
10131,N62223
10131,N62979
10131,NG447
10131,NG448
10131,NG449
10131,NG451
10131,NG480
10131,NG498
10131,NG500
10131,NG507
10131,NG508
10131,NG509
10131,NG510
10131,NG525
10131,NG528
10131,NG531
10131,NG532
10131,NG547
10131,NG554
10131,NG558
10131,NG568
 
D

dangerzone21

Pay attention to how you are uploading via the FTP, you have to uploa
it in text (ASCII) mode, not binary, or automatic, let me know if tha
helps
 
J

Jim Rech

I think the issue is discussed here. Seems to be an Excel problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;77295&Product=xlw

--
Jim Rech
Excel MVP
| Currently I have a customer that wants me to send them a
| in file in csv format with cetain column headings.
|
| After we save this file it is sent via ftp to a customer
| and the import this into a database.
|
| As you can see the 1st 15 lines work well. Empty spaces
| are seperated by a comma. After aprox 15 spaces the comma
| seperation stops. Not sure why? Can anyone advise.
|
| Carrier,BolNbr,ShipmentNbr,ProNumber,ApptDate,DeliveryDate,
| ContactDate,ContactName,Comment
| 10131,M60506,,,,,,,
| 10131,M61070,,,,,,,
| 10131,M61234,,,,,,,
| 10131,M61320,,,,,,,
| 10131,M61476,,,,,,,
| 10131,M61676,,,,,,,
| 10131,M61905,,,,,,,
| 10131,M61911,,,,,,,
| 10131,M61947,,,,,,,
| 10131,M62019,,,,,,,
| 10131,M62548,,,,,,,
| 10131,M62571,,,,,,,
| 10131,M62879,,,,,,,
| 10131,M63019,,,,,,,
| 10131,M63166,,,,,,,
| 10131,M63168
| 10131,M63656
| 10131,N62223
| 10131,N62979
| 10131,NG447
| 10131,NG448
| 10131,NG449
| 10131,NG451
| 10131,NG480
| 10131,NG498
| 10131,NG500
| 10131,NG507
| 10131,NG508
| 10131,NG509
| 10131,NG510
| 10131,NG525
| 10131,NG528
| 10131,NG531
| 10131,NG532
| 10131,NG547
| 10131,NG554
| 10131,NG558
| 10131,NG568
|
 
Top