|
| |
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
 |
Change files to .csv from .xls - 6/18/2009 15:12:27
I have around 500 files in a directory i would like to change from .xls to .csv...for some reason, they are not saved correctly as csv files, and I need to change them all at one click instead of one at a time.
So, how would I go about doing that? I would have the necessary permissions already.
|
|
|
|
swoosh
Posts: 1535
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Change files to .csv from .xls - 6/18/2009 16:11:17
Don't think you're going to be able to do all of them without the help of third party software, but of course that is gonna cost. Link below is for one that will do exactly what your looking for but is it worth the price?
http://www.ozgrid.com/Services/convert-excel-csv.htm
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Change files to .csv from .xls - 6/18/2009 16:22:20
All of the files are labled 1.xls all the way up to 530.xls. I've renamed files through asp code before, I just do not remember how to do it. Once I get the code to rename one file, then i can put it into a loop and be able to do it.
| |
|
|
|
swoosh
Posts: 1535
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Change files to .csv from .xls - 6/18/2009 23:16:01
quote:
If a command window just use the ren command.
ren *.csv *.xls
Just beware that this will work fine with the renaming and using the files within Excel. However, for text editors such as notepad they will be corrupt.
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
ou812
Posts: 1703
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: Change files to .csv from .xls - 6/19/2009 1:10:43
Ah, got it. I thought maybe you experienced something strange when renaming different types of files. But yes, you are correct, renaming does nothing at all to the file except allows a program to read it by default. If the contents are really CSV then notepad, or any text type editor will have no problem with it. And as you said, if you renaming an XLS file, that was created as a spreadsheet, to a CSV extension, or txt or something, notepad and other text editors will not be able to view them very nicely.
Thanks for clarifying, and sorry for my confusion. 
_____________________________
-brian
Black Holes suck.
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
