Saving Comma Separated .txt files as .csv files

Hello Everyone,

I have a large number of .txt files that are comma separated files (but not saved with the .csv extension) that I need to convert to files with the .csv extension.

Is there an easy way to do this for all files in a given folder? Ideally, the files don't even need to be opened as they are are quite large in size (70MB+) and there are a lot of them (500+).

Any code snippets would be greatfully received.

Many thanks for your time,
twills

pike,

Unfortunately a third party application that reads .csv files but not .txt files

Kindest Regards,
twills

i cant say which application you are using to choose files

but most of the applications usees default extension in browse / open window
under files of Types to populate files under that ext ..

While selecting your CSV, just press *.txt and enter, which will populate all txt files under that folder..., rest your application should take that file as format seams same ......

but again that depends on which application you have used...


Vora

Pike & Vorabha,

Many thanks for your suggestions.

The third party application I'm using simply looks in a folder for files with a .csv extension. If there aren't any there (such as in this case), it simply reports that no .csv files could be found, hence the necessity to perform the conversion from .txt to .csv before the third party app takes over.

Changing the extension manually would work, but there are over 500 of the blighters, so it may take me a while

Would it be possible to get vba to cycle through each of the files in a folder (without opening them) and simply do a saveas with the extension as the required .csv?

Kindest Regards,
twills

Get to the Command Prompt, change directory and use the DOS REN command, REN *.txt *.csv

hv you tried my way, by typing *.txt ??, it worked for me..

well other way is take list of files in commandprompt by

Please Login or Register  to view this content.

this will list our file name, in xls open and sep them with text to columns, take ext also out of file names.

run a simple rename command in way excel returns value as

Please Login or Register  to view this content.

save this results in new notepad, save as .bat and run ..


Vora