Dear all,
I've got the same need: to parse & save a few long ASCII files into one XLS multi worksheet file. I've tried the ActiveX solution and found it works tooooooo sloooooooow by executing my simple task.
Thanks to this topic and Phillip Brooks I've learned about "ADO Toolkit". I've checked it, but have got an error warning: "Error -2147467259 occurred at Exception occured in Microsoft OLE DB Provider for ODBC Drivers: System error 126 (Microsoft Excel-Treiber (*.xls)) the driver couldn't be loaded in ADOTool_ADO API.vi->ADOTool_Open Excel Database.vi->dir_of_txt_to_multi_worksheet_xls_c.vi"
Heir are the attachments: the block diagram and VI.
Unfortunately I couldn't debug my vi with myself and would appreciate any suggestions!
P.S. I use LabView 8.0 SE with ADO-Tool.1.5.LV80