Anyone know how to program transfer of CSV data to web page form fields?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jcnone@none.com - 28 Jan 2008 01:03 GMT

How can you populate a form fields on a html web page (client side)
with data from an Excel file (CSV). The web page has several text
fields for input that I manually populate. I would like to transfer
the data into the web form automatically from the CSV file. How can
this be done?
TIA
Jman

--
--------------------------------- --- -- -
Posted with NewsLeecher v3.7 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Reply to this Message

Joel - 28 Jan 2008 11:42 GMT

CSV files are not really excel files, they are just ordinary text files. You
can open CSV just like any other text files and read the data. Each line of
data has multiple fields seperated by commas and a line return at the end of
each line.

I don't know webpages that well, but determine if it is easier to just open
the CSV as text in HTML or open an excel file and copy a range of data.

"jman" wrote:

> How can you populate a form fields on a html web page (client side)
> with data from an Excel file (CSV). The web page has several text
[quoted text clipped - 9 lines]
> Web @ http://www.newsleecher.com/?usenet
> ------------------- ----- ---- -- -

Reply to this Message

Tim Williams - 29 Jan 2008 05:08 GMT

Google for "IE automation VBA"

Eg:
http://p2p.wrox.com/topic.asp?TOPIC_ID=43120

Tim

Reply to this Message