Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

How to convert/save an Excel file to ASCII comma delimited text file


(!)

rpallipamu's Avatar
rpallipamu rpallipamu is offline
Junior Member with 1 posts.
THREAD STARTER
 
Join Date: Mar 2010
Experience: Intermediate
10-Mar-2010, 12:26 PM #1
How to convert/save an Excel file to ASCII comma delimited text file
I need convert/save Excel files into the ASCII comma delimited text files. It needs to be in this format in order to upload healthcare data to the CDC (NHSN).

Thank you.
Alternatech's Avatar
Alternatech Alternatech is offline
Computer Specs
Member with 148 posts.
 
Join Date: Feb 2010
Location: Atlanta, GA
Experience: Advanced
10-Mar-2010, 12:35 PM #2
File - Save As. Change Save as type option at the bottom...
Rollin_Again's Avatar
Member with 4,699 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
11-Mar-2010, 11:30 PM #3
To expand further on what has already been said, click FILE >> SAVE AS and then change the file type to CSV and then save to the location of your choice. Then you just need to right click on the newly created CSV file and choose OPEN WITH and select Notepad. Once the file opens in Notepad you just need to re-save with .txt as the extension. Another option is to use a macro to create the text file for you but this is overkill in the situation.


Regards
Rollin
sadert's Avatar
sadert sadert is offline
Junior Member with 16 posts.
 
Join Date: Oct 2006
Experience: Intermediate
11-Mar-2010, 11:59 PM #4
Depends on what format your database requires it.If it's CSV then as suggested above save it as .csv and you are done.If you require text file then open with notepad and convert but in some cases encoding needs to be checked.In notepad you can encode it as ansi or unicode.In most cases unicode works,but just play with it and see. All the best.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑