I've been asked to convert .xls files to .csv directly on a server. Theire is no possibility to install MS Excel on the server for security reasons.
So I was wondering if installing some DLLs could do the trick ?
If your xls files have a header for each column and then data underneath, you may be able to use ADO to query the file like it was a DB and then just write out to a .csv file using the FileSystemObject or ADO.
--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.