Question Locked

Automatically export csv data to xls file

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all.
I have created a form in Frontpage 2003 that collects data into a csv file. I can export it into an xls file on a different server easy enough but what I've been trying to figure out is if there is a way for this to occur automatically. Is there a way to set up the csv file to periodically export data to an xls file?
Thank you!

6 replies

by fred123456

Just curious as to why. A CSV file is opened and functioninal within Excel.

But you could write a VBScript to open it in excel and save it as an xls.

by gbarn

The csv file won't be available to the user who will need the data from it. And as the csv file will continually collect data from submitted forms, I wanted the data to periodically update an xls file.
Thanks!

by gbarn

Thanks for your help :)
I decided to use a mdb instead.

This discussion is closed to new replies.