Convert .tsv file to .xlsx file

[Paul Stras]

Hi everyone
I need to convert a .tsv file to an .xlsx file, but only for selected fields. That is, the original .tsv file has about 100 fields but I want to extract only about 20 of them and create an .xlsx file. I am using Excel 2007, and there are many records.

I was thinking of using pl/sql or something like that. Can it be done with a macro in Excel, or any other way? - Paul

[Andy Pope]

what's a .tsv file, is it TAB separators?
Recorded this macro whilst using the Data Import of a text file.
Not the use of the Array for the TextFileColumnDataTypes property.
1 denotes general data
9 denotes skip field.

Please Login or Register  to view this content.

[Paul Stras]

I think that code may be the kind of thing I need. The "tsv" in .tsv files does actually stand for "tab delimited values" but in my file the delimiter is a vertical bar ( | ), So I guess I would need a line something like
.TextFile????Delimiter = True
Where the ???? is "vertical bar" or something. Do you know what it would be? - Paul

[Andy Pope]

macro record says....

Please Login or Register  to view this content.

[Paul Stras]

This is working. Thanks Andy! - Paul S =:-D