uploading large files

BEFOR

I'm uploading large files and need to make a table to accomodate the files.

However these are not in formats I'm used to:

"csv" -- is in two seperate files (larger that 70,000 rows total)
This is actually already in an excel file format, not comma seperated txt file as I once thought.

"fixed" txt file -- is tab delimited " in single txt file but without commas, how could this be tansferred to include commas //having only notepad//

What's the best way to go about this? I have only columns and many rows at this point.

phpmaydmin interface being used to scan my local desktop.

--character set reads utf8 -- this alright?

nemonoman

Use PHP to open the tab delimited file

read the file into a string.

str_replace (chr(90, ',' $mystring);

save the string as a file.

The new file can be uploaded as a csv.

BEFOR

I've discoverd the tab delimited is missing records.

Thre are two xls excel worksheet files.

The new file can be uploaded as a csv.

don't see an option for this in phpmyadmin 2.6.0. how?
this is csv in excel format, not .txt

Is there a way to do it with this?

Tried saving as a web page then to a text file but its simply too large to open as a web page and resave