Excel sheet Conversion to Text File

[GrandMauler]

I'm attempting to write an SSIS Package that will read an Excel sheet into a table.

Due some formatting issues (too many to go into), I have decided the best way is to export the XL sheet into a simple text file.

Granted that SSIS does have the capability to export an excel source into a text destination. However, even this seems to be a problem.


So now I'm looking for a workaround, namely a VB script that will read an XL sheet and spit it out as a simple, tab delimited, text qualified file.


Can anyone point me in the right direction?


Thanks in advance.

 

[drlex]

GM,
I suspect you may have solved this or tried another tack, but on the off-chance that you haven't (or that someone else may check this thread), have you tried a simple cycle of create Excel session -> open <filename.xls> -> SaveAs <filename.csv>, Fileformat:=6 ?

Lex
(looking at threads involving SSIS to see whether one can edit a migrated SS2000 DTS package and getting despondent)

soi la, soi carré