i am building my website usinf front page . For that i am using excel file as database. i have created excel database through OLEDB first i created system DSN i used database result wizard for that(insert->db->result) my excel file is coming with all column names witth no records. When i save that web page and preview it in preview option i am getting this meeage below columns. Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.
See response to your above post PS In design view you will never see the DB results - most be run from a server And although you can use a Excel as a DB, - it is not recommended (Excel is a single user app) - use Access for your data source instead -- _____________________________________________ SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ] "Warning - Using the F1 Key will not break anything!" (-; _____________________________________________ "Tigerxxx" wrote in message news:CE27436D-AD33-4CE8-9792-E37127F92EDD@microsoft.com... |i am building my website usinf front page . For that i am using excel file as | database. i have created excel database through OLEDB | first i created system DSN | i used database result wizard for that(insert->db->result) | my excel file is coming with all column names witth no records. When i save | that web page and preview it in preview option i am getting this meeage below | columns. | | Database Results regions will not preview unless this page is fetched from a | Web server with a web browser. The following table row will repeat once for | every record returned by the query. |