Convert CSV Files to XLS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SowBelly - 30 Jul 2004 23:05 GMT

Hello:

I have approximately 1300 .csv files that I need to convert to .xls
files so I can extract data from a master spreadsheet. Excel
apparently requires a .csv file be open to extract the data.

I could open each one individually and do a save as, but that would be
rather tedious. Is there a way to programmatically do this. The .csv
files are in the following format:

xxnzz.csv where:

xx is 01-29 (notice the leading 0)
n is n
zz is 01-110 (notice the leading 0 on 1 digit numbers and that the
highest number is 3 digits, 2 digit numbers have no leading 0 i.e.
21n99.

"Pigs can't be humans, but humans can be Pigs!"

Eating at the trough of life.

Oink!

SowBelly

Reply to this Message

Dave Peterson - 30 Jul 2004 23:55 GMT

You didn't care for yesterday's answer:

http://google.com/groups?threadm=gp6jg05mrscko6dtf7oi6is3uh9gkhaqrj%404ax.com

If you're looking for old posts, you can use google (maybe a few hours behind)
to search for stuff you've posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

> Hello:
>
[quoted text clipped - 21 lines]
>
> SowBelly

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

SowBelly - 31 Jul 2004 01:45 GMT

Dave:

Sorry, I didn't see it. Appreciate you repeating.

"Pigs can't be humans, but humans can be Pigs!"

Eating at the trough of life.

Oink!

SowBelly

>You didn't care for yesterday's answer:
>
[quoted text clipped - 34 lines]
>>
>> SowBelly

Reply to this Message