|
Prev: Disable picture manager as editor for thumbnails in fontpage 200
Next: Uploading video with frontpage
From: Tigerxxx on 10 Jul 2008 19:52 I am designing my web site usin front page using excel db...When i run databbse result wizard ...i am getting this error...plz tell me how to solve this error?? Server error: Unable to connect to a database from the Web server using the connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'. The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ------------------------------------------------------- [Microsoft][ODBC Excel Driver] External table is not in the expected format. Source: Microsoft OLE DB Provider for ODBC Drivers Number: -2147467259 (0x80004005) thanks in advance
From: Stefan B Rusynko on 11 Jul 2008 07:02 Is your Excel worksheet set up correctly as a data table with acceptable data column headings without any spaces FYI - use of Excel as a DB is not recommended - convert your Excel worksheet to an Access database -- _____________________________________________ 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.net-sites.com/sitebuilder/newsgroups.asp _____________________________________________ "Tigerxxx" <Tigerxxx(a)discussions.microsoft.com> wrote in message news:B4C432E9-449D-4EED-806A-34CF93F0C92C(a)microsoft.com... |I am designing my web site usin front page using excel db...When i run | databbse result wizard ...i am getting this error...plz tell me how to solve | this error?? | | | Server error: Unable to connect to a database from the Web server using the | connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'. | | The following error message comes from the database driver software; it may | appear in a different language depending on how the driver is configured. | ------------------------------------------------------- | [Microsoft][ODBC Excel Driver] External table is not in the expected format. | | Source: Microsoft OLE DB Provider for ODBC Drivers | Number: -2147467259 (0x80004005) | | | thanks in advance
From: Tigerxxx on 11 Jul 2008 11:04 Thanks stefan.. I will convert my excel to access. If i want to display my records should i run it on webb server? or should i preview it on web broswer to see my records? "Stefan B Rusynko" wrote: > Is your Excel worksheet set up correctly as a data table with acceptable data column headings without any spaces > > FYI > - use of Excel as a DB is not recommended > - convert your Excel worksheet to an Access database > > -- > > _____________________________________________ > 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.net-sites.com/sitebuilder/newsgroups.asp > _____________________________________________ > > > "Tigerxxx" <Tigerxxx(a)discussions.microsoft.com> wrote in message news:B4C432E9-449D-4EED-806A-34CF93F0C92C(a)microsoft.com... > |I am designing my web site usin front page using excel db...When i run > | databbse result wizard ...i am getting this error...plz tell me how to solve > | this error?? > | > | > | Server error: Unable to connect to a database from the Web server using the > | connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'. > | > | The following error message comes from the database driver software; it may > | appear in a different language depending on how the driver is configured. > | ------------------------------------------------------- > | [Microsoft][ODBC Excel Driver] External table is not in the expected format. > | > | Source: Microsoft OLE DB Provider for ODBC Drivers > | Number: -2147467259 (0x80004005) > | > | > | thanks in advance > > >
From: Kathleen Anderson on 11 Jul 2008 11:22
You need to run this on a Windows server that supports ASP and Access. -- ~ Kathleen Anderson Microsoft MVP - FrontPage Spider Web Woman Designs Expression Web Resources: http://www.spiderwebwoman.com/xweb/ FrontPage Resources: http://www.spiderwebwoman.com/resources/ Please reply to the newsgroup for the benefit of others "Tigerxxx" <Tigerxxx(a)discussions.microsoft.com> wrote in message news:28A1F73C-BA78-46DC-BFA2-FCE2A1B5D963(a)microsoft.com... > Thanks stefan.. > I will convert my excel to access. If i want to display my records should > i > run it on webb server? or should i preview it on web broswer to see my > records? > > "Stefan B Rusynko" wrote: > >> Is your Excel worksheet set up correctly as a data table with acceptable >> data column headings without any spaces >> >> FYI >> - use of Excel as a DB is not recommended >> - convert your Excel worksheet to an Access database >> >> -- >> >> _____________________________________________ >> 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.net-sites.com/sitebuilder/newsgroups.asp >> _____________________________________________ >> >> >> "Tigerxxx" <Tigerxxx(a)discussions.microsoft.com> wrote in message >> news:B4C432E9-449D-4EED-806A-34CF93F0C92C(a)microsoft.com... >> |I am designing my web site usin front page using excel db...When i run >> | databbse result wizard ...i am getting this error...plz tell me how to >> solve >> | this error?? >> | >> | >> | Server error: Unable to connect to a database from the Web server using >> the >> | connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'. >> | >> | The following error message comes from the database driver software; it >> may >> | appear in a different language depending on how the driver is >> configured. >> | ------------------------------------------------------- >> | [Microsoft][ODBC Excel Driver] External table is not in the expected >> format. >> | >> | Source: Microsoft OLE DB Provider for ODBC Drivers >> | Number: -2147467259 (0x80004005) >> | >> | >> | thanks in advance >> >> >> |