Hi Larry,
I didn’t explain what I did in my eagerness to get the (hopefully) answer to
you.
I took a tab-delimited file (test.txt) and changed the extension (test.csv) and
it open up and got the squares between fields.
If this didn’t work.
If you opened the text file in Notepad and saw the little Squares.
When you import the file and get the “import database wizard” try changing the
“File Origin” which can affect how the different characters are displayed on
your system. Could be that I suppose.
Bill Buker
VBA Developer
From: Larry Flowers via excel-l [mailto:excel-l@Groups.ITtoolbox.com]
Sent: Thursday, June 12, 2008 3:57 PM
To: JustPlainBill
Subject: RE:[excel-l] Converting .txt to .csv files
Hi Bill,
Thanks for the response!
I see the Wizard but when I select Comma Delimited, nothing happens.
Actually, instead of commas, the are little boxes that were probably
generated during the .txt to .csv conversion. I’ve seen where the Tab
key translates to these boxes…
Cordially,
Larry L Flowers System Support Analyst
Tel:800.727.1133 x1309 direct
707.338.6102 mobile
707.762.0802 fax
lflowers@vurv.com
From: JustPlainBill via excel-l [mailto:excel-l@Groups.ITtoolbox.com]
Sent: Thursday, June 12, 2008 12:49 PM
To: Larry Flowers
Subject: RE: [excel-l] Converting .txt to .csv files
Hi Larry,
So you navigate to your text file, select it, then click ‘Open’.
Do you see the text file import wizard after that?
If so, click ‘Next’ and try different delimiters.
I was able to duplicate your issue when I chose ‘comma’ as the delimiter
on a
tab-separated file.
Open your text file in notepad and make sure it is comma separated.
Bill Buker
VBA Developer
From: Larry Flowers via excel-l [mailto:excel-l@Groups.ITtoolbox.com]
Sent: Thursday, June 12, 2008 3:23 PM
To: JustPlainBill
Subject: RE:[excel-l] Converting .txt to .csv files
I am opening Excel, then File/Open, then browse to my text doc.
Where in Excel is the ‘Clean’ feature?
Cordially,
Larry L Flowers System Support Analyst
Tel:800.727.1133 x1309 direct
707.338.6102 mobile
707.762.0802 fax
lflowers@vurv.com
From: JustPlainBill via excel-l [mailto:excel-l@Groups.ITtoolbox.com]
Sent: Thursday, June 12, 2008 12:06 PM
To: Larry Flowers
Subject: RE:[excel-l] Converting .txt to .csv files
Larry,
How are you doing the conversion? “Save As”? “Data > Import”? Some other
method?
Are you doing it manually or with VBA?
Additionally, is your data clean? You can use the CLEAN(cell Reference)
function
to remove all non-printing characters in a worksheet.
Bill Buker
VBA Developer
From: Larry Flowers via excel-l [mailto:excel-l@Groups.ITtoolbox.com]
Sent: Thursday, June 12, 2008 2:19 PM
To: JustPlainBill
Subject: [excel-l] Converting .txt to .csv files
When I attempt to convert a .txt file, while in MS Excel, boxes are
displayed,
opposed to commas.
Any clue as to what is causing this phenomenon?
Thank you in advance,
Srewolf
