XLS to CSV file in notepad

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
 
L

Lady Layla

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
:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing from a Notepad file 3
Excel And Notepad 3
Access Importing csv daily files into access 2007 1
import file so that it is a actual csv file, no excel cell version 1
Convert a csv to xls prior to import 2
ONE xls column to file? 2
Import from Notepad delimited text 7
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Top