Automatically export csv data to xls file

By gbarn ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by Fred123456 In reply to Automatically export csv ...

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.

Collapse -

Re: Why?

by gbarn In reply to Why?

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.

Collapse -


by gbarn In reply to Re: Why?

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

Collapse -


by gbarn In reply to VBS or Python

I decided to use a mdb :)

Related Discussions

Related Forums