Converting CSV to Excel (.xls) files

[feiner99]

Hi there!

May sound like a newbie question.

I have a web application (running under *nix, by the way).
The users need to convert databases from Excel spreadsheets into flat file databases (CSV) like this:

01-02-C01-005-02|R|Gruppenführer|18-03-02|22-03-02|48
01-02-C01-006-02|R|Gruppenführer|15-04-02|19-04-02|48
01-02-C18-008-02|W|Jugendwart Teil 2|27-11-02|29-11-02|24
01-02-C20-001-02|W|Drehleitermaschinisten|11-03-02|15-03-02|15
01-02-C21-001-02|W|Bootsführer|13-05-02|17-05-02|12
01-02-C28-001-02|W|Techn. Hilfeleistung RW|11-03-02|15-03-02|32
01-02-C04-001-02|G|Leiter einer Feuerwehr|07-01-02|10-01-02|24

and vice versa, if possible.

Does somebody know about some sample codes in VBS or VBA?

I found a few things using VB 6.0 or VB 7.0, but these are of no value for the users for they are no programmers at all.

The whole thing should function by simply installing the WSH and performing a few clicks and/or enterings in some text fields to name the pathes to the resp. files to be read or created.

Thanks in advance for any useful hints.

Andreas