From: Tigerxxx on
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
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
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
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
>>
>>
>>