rrodgers
|
Posted: 06/16/2003, 4:22 PM |
|
http://www.sylvancomputing.com/ccs/csvexport/
Here is an example of exporting to a CSV. I had to do this for a customer, and it seems to work.
Rob
|
|
|
rrodgers
|
Posted: 06/27/2003, 10:01 AM |
|
I have updated the example. It now uses a class and can either export directly from your grid or from an sql statement.
This code exports from your grid.
Dim x
Set x = New clsExportCSV
With x
'Set properties and add data to class here.
'.Contenttype = "something"
'.AddHeader("HeaderName","HeaderValue")
.ExportGridRecords MyGrid.Recordset
End With
Set x = Nothing
This code exports from a sql statement
sSQL = "SELECT Something from somewhere"
Set x = New clsExportCSV
With x
'Set properties and add data to class here.
'.Contenttype = "something"
'.AddHeader("HeaderName","HeaderValue")
.ExportSQLRecords DBConnection1,sSQL
End With
Set x = Nothing
|
|
|
Bill Noble
|
Posted: 06/27/2003, 12:30 PM |
|
Thanks
|
|
|
rrodgers
|
Posted: 06/27/2003, 2:48 PM |
|
Your welcome Bill.
rob
|
|
|
|