Field in form from a column in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm wondering if it's possible to have in a form a field that would display a
list of items that come from a column in an excel spreadsheet that could
reside on my web site. I would like the people filling this form to be able
to chose multiple items in this list? If it can't be done from an excel file
directly do any of you have an idea my source will be this excel file put I
could certainly transpose the data elsewhere!

Thanks a lot for your response!
 
Hi Mike,

One way to accomplish is to use a database connection string pointing to the excel file. You can then read the column just like
reading from a database.
 
See http://support.microsoft.com/default.aspx?scid=268948

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi Mike,
|
| One way to accomplish is to use a database connection string pointing to the excel file. You can then read the column just like
| reading from a database.
|
| --
| Mike
| http://www.websunlimited.com
| FrontPage Add-in
| MVP FrontPage '97 - '02
|
| > I'm wondering if it's possible to have in a form a field that would display a
| > list of items that come from a column in an excel spreadsheet that could
| > reside on my web site. I would like the people filling this form to be able
| > to chose multiple items in this list? If it can't be done from an excel file
| > directly do any of you have an idea my source will be this excel file put I
| > could certainly transpose the data elsewhere!
| >
| > Thanks a lot for your response!
| > --
| > Mike Vautour
|
|
 
Back
Top