D
don_ingli
All,
I have 26 csv files named a.txt .. z.txt.
I want to be able to import all of these files using the name of
the .txt file as the name of a tab and import all data as text not
general.
The end result would be a single xls file with 26tabs of TEXT (not
general) imported data.
Any way i can automate this?
The format of the .txt files is from an output of my own app so i
could turn it into html if that helps any except these import files
are around 50,000 rows each.
Thanks.
Please email me your posts.
I have 26 csv files named a.txt .. z.txt.
I want to be able to import all of these files using the name of
the .txt file as the name of a tab and import all data as text not
general.
The end result would be a single xls file with 26tabs of TEXT (not
general) imported data.
Any way i can automate this?
The format of the .txt files is from an output of my own app so i
could turn it into html if that helps any except these import files
are around 50,000 rows each.
Thanks.
Please email me your posts.