CSV to ASCII

Q

Quco

What is the CORRECT procedure to convert a CSV file (a comma delimited file)
that I created using Excel 2007, to an ASCII file? I think there is more than
just changing the extencion from *.csv to *.asc
 
B

Bob I

Depends entirely on the application that is "expecting" the .asc file.
But you may get by just renaming. A ".csv" file just "generally" means
its a text file with the "fields" separated by commas.
 
K

Kevin B

Open the FILE OPEN dialog box, change the files of type option to text files,
where csv is one of several extensions, locate your csv file and the import
wizard should open allowing to define how to parse the data.
 
D

David Biddulph

I don't think the OP was asking how to open the file with Excel, but as a
matter of interest, which version of Excel opens the wizard for File/ Open
of a csv, Kevin?
In general (such as in Excel 2003), to get the wizard one has to change the
csv extension to txt, or open the file with Data/ Import External Data; a
simple File/ Open of a csv bypasses the wizard and Excel decides what it
wants, rather than what *you* want. :-(
 

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

Macro Loop 0
Adding data to MS Access from csv file 0
Excel CSV Files; Creating Of 3
.csv Commas ? 2
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Puzzling quotes around text 2
how do I change a csv extension file to an xls file and use it? 1
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top