![]() |
Exporting CSV files
A major customer of my client is requiring an upload of
certain daily performance of service data each night as a .csv export from an Excel spread sheet. These data have already been entered into a VB.net database in a program we already have in place. I know the format of the data cells for each record, and can create comma separations, but need to know the end of field character that is used to designate the end of a record when exporting data. Right now my client has to enter virtually the same data twice, so I want to be able to create a report from the VB program and export it to the customer website in the correct format. |
Exporting CSV files
crlf marks the end of a record
chr(13) & chr(10) -- Regards, Tom Ogilvy "Hank Myers" wrote in message ... A major customer of my client is requiring an upload of certain daily performance of service data each night as a .csv export from an Excel spread sheet. These data have already been entered into a VB.net database in a program we already have in place. I know the format of the data cells for each record, and can create comma separations, but need to know the end of field character that is used to designate the end of a record when exporting data. Right now my client has to enter virtually the same data twice, so I want to be able to create a report from the VB program and export it to the customer website in the correct format. |
All times are GMT +1. The time now is 03:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com