asked on converting web .txt or .dat file into an xls file
I am crunching data and need to convert the data from the website
http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt
to a xls file. How would I do that?
Also I am looking at data from this website and need to convert the files to xls format as well. http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt
http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt
to a xls file. How would I do that?
Also I am looking at data from this website and need to convert the files to xls format as well. http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt
Microsoft OfficeDatabasesProgramming
Last Comment
Norie
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I have resolved the issue by using my mac instead of pc. I simply downloaded the file as a txt file and uploaded it to a linux account then used cat to join the files. I'm still looking to average the files per month. See my other questions.
mwochnick
A vb macro? I was actually thinking of doing it with VBA, no macros.
A vb macro? I was actually thinking of doing it with VBA, no macros.