View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.