FrontPage Forms CSV HTML

E

Emmett Power

Hi,

I have a number of FrontPage forms on different pages. I am having
quite a lot of problems saving the data in a simple usable format.

I want to save all the data in a flat CSV file for importation into
Excel. I have two problems:

First: In order to do so I have specified the File fomat as CSV and
set the File Format at: "Test database using comma as a separator".
Despite this the file is saved with the data in html format. This is
unusable. How can I remedy this and have the data stored in a simple
flat file?

Second: I have a problem where the csv files are in non-html format.
Some of the forms have drop down menus that allow for multiple
selections. The CSV file that is generated provides columns labled
"Option1" "Option2" "Option3" and so on. I'd rather that data was
stored in one column separated by commas or spaces. How can this be
done?

Thanks for your help.


Emmett Power
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV files and having numbers and strings in there... 9
CSV->Excel Data Problem 1
Excel VBA macro to auto import new CSV file from fixed directory 1
importing a .csv so data on new lines? 3
csv format is wrong in Denmark 3
CSV error when trying to save 3
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
VBA code To Merge All .csv files into a single excel sheet (data start from row 11th) 2

Top