XLS to CSV file in notepad

  • Thread starter Thread starter lmk001
  • Start date Start date
L

lmk001

I want to convert a table that I have in an excel file into notepad as
CSV file so I can import it into a mysql table. For example in m
Record I have licenseID 30 and licensee Albright College. When
import the excel table license.xls to notpad my record will look lik
this: 30,"Albright College ". But, what I want is for all of m
records to look like this: 30[TAB]"Albright College". Could someon
tell me how I can import a xls file into this format
 
SAve as a Tab deliminated format rather than Comma deliminated


:
: I want to convert a table that I have in an excel file into notepad as a
: CSV file so I can import it into a mysql table. For example in my
: Record I have licenseID 30 and licensee Albright College. When I
: import the excel table license.xls to notpad my record will look like
: this: 30,"Albright College ". But, what I want is for all of my
: records to look like this: 30[TAB]"Albright College". Could someone
: tell me how I can import a xls file into this format.
:
:
: --
: lmk001
: ------------------------------------------------------------------------
: lmk001's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=10002
: View this thread: http://www.excelforum.com/showthread.php?threadid=269011
:
 
Back
Top