I have nearly completed my SQL script and am being instructed to export the results table to an Excel file. Is that possible through SQL statements in DBISam? Or will that need to be done through the table editor? Thank you.

JansB


There's nothing in DBISAM which will export to native Excel format. If that's what is needed you'll have to buy a third party tool (check out scalabium.com). However, if all they want is a file that Excel can read you can export in csv format. You should be able to do that with the ExportTable method of the query.

I'm well out of date with DBISAM (4.25) so check out the pdf help file for an example.

Roy Lambert [Team Elevate]

Thank you once again for the help.

If you write out a CSV file - excel can open it directly.

"First Name","Last Name","Address",City"
"John P.,"Smith","123 Somewhere St.","Cornwall"
"Mary","Joans","","Tichbourne"



Simple to do....

Walter