I'm having trouble extracting data out of Excel 2002 Workbook files in SQL
Server 2000 DTS. I want to use an ActiveX task to save the Excel file as a
tab delimitted text file and then import the data from there. Something
like:

set theFile = pkg.Connections("Excel File")
theFilse.SaveAs "C:\file.tx."

Can this be done with VBA?

(Specifically, when the column in the Excel file is > 255 characters I can
use the IMEX switch and registry settings to select the data correctly--such
as using the opendatasource command--but when I try and insert the text data
into a SQL table I get junk for any column where the length is > 255.)

Thanks,

Walter