form POST to excel

T

thrashcat

I am trying to set a form to post to an excel db, Is this
possibe? If so, what connection string is required and
what do I need to set in the form/excel properties to
allow the db to be written to? thanks
 
T

thrashcat

Have tried as this says but I keep getting this error:

Server error: Unable to retrieve schema information from
the record source 'DataAll' in a database using the
connection string:

'DRIVER={Microsoft Excel Driver
(*.xls)};DBQ=URL=fpdb/Dan.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] Too many fields defined.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
-----Original Message-----
See http://support.microsoft.com/default.aspx?scid=268948




"thrashcat" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
T

thrashcat

As usual ABSOLUTLY NO HELP FROM THE MICROSOFT PROFESSIONAL IDIOTS!!!!!

thrashcat said:
Have tried as this says but I keep getting this error:

Server error: Unable to retrieve schema information from
the record source 'DataAll' in a database using the
connection string:

'DRIVER={Microsoft Excel Driver
(*.xls)};DBQ=URL=fpdb/Dan.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] Too many fields defined.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
-----Original Message-----
See http://support.microsoft.com/default.aspx?scid=268948




"thrashcat" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
| I am trying to set a form to post to an excel db, Is this
| possibe? If so, what connection string is required and
| what do I need to set in the form/excel properties to
| allow the db to be written to? thanks


.
Click to expand...
Click to expand...
 
K

Kevin Spencer

You did get help, but you won't be getting any more, that's for sure.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

thrashcat said:
As usual ABSOLUTLY NO HELP FROM THE MICROSOFT PROFESSIONAL IDIOTS!!!!!

thrashcat said:
Have tried as this says but I keep getting this error:

Server error: Unable to retrieve schema information from
the record source 'DataAll' in a database using the
connection string:

'DRIVER={Microsoft Excel Driver
(*.xls)};DBQ=URL=fpdb/Dan.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] Too many fields defined.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
-----Original Message-----
See http://support.microsoft.com/default.aspx?scid=268948




"thrashcat" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
| I am trying to set a form to post to an excel db, Is this
| possibe? If so, what connection string is required and
| what do I need to set in the form/excel properties to
| allow the db to be written to? thanks


.
Click to expand...
Click to expand...
Click to expand...
 
T

Tom Pepper Willett

....and no more to come, you ungrateful juvenile acting child.
<plonk>
| As usual ABSOLUTLY NO HELP FROM THE MICROSOFT PROFESSIONAL IDIOTS!!!!!
|
| "thrashcat" wrote:
|
| > Have tried as this says but I keep getting this error:
| >
| > Server error: Unable to retrieve schema information from
| > the record source 'DataAll' in a database using the
| > connection string:
| >
| > 'DRIVER={Microsoft Excel Driver
| > (*.xls)};DBQ=URL=fpdb/Dan.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] Too many fields defined.
| >
| > Source: Microsoft OLE DB Provider for ODBC Drivers
| > Number: -2147467259 (0x80004005)
| > >-----Original Message-----
| > >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.net-sites.com/sitebuilder/newsgroups.asp
| > >_____________________________________________
| > >
| > >
| > in message | > >| I am trying to set a form to post to an excel db, Is
| > this
| > >| possibe? If so, what connection string is required and
| > >| what do I need to set in the form/excel properties to
| > >| allow the db to be written to? thanks
| > >
| > >
| > >.
| > >
| >
 
M

Mike Mueller

Thrashcat...

Seeings I can't go back that far to check the post and
replies, I have to go what little is here...

Are you using Excel 2000? It can only handle 32 fields- if
there are more than that you will get that error
Why not Access? FP can do the form post natively, it can do
more fields, and it is a db, not a spreadsheet. You could
always use some script to pull the info from the db and put
it into your spreadsheet.

More details please....

Bashing people who voluntarily try to help will get you
nowhere. Did you ever think that the pros may not know how
to do this as maybe the pros are smarter than to use excel
as a db for a web

Mike



thrashcat wrote:
: As usual ABSOLUTLY NO HELP FROM THE MICROSOFT
: PROFESSIONAL IDIOTS!!!!!
:
: "thrashcat" wrote:
:
:: Have tried as this says but I keep getting this error:
::
:: Server error: Unable to retrieve schema information from
:: the record source 'DataAll' in a database using the
:: connection string:
::
:: 'DRIVER={Microsoft Excel Driver
:: (*.xls)};DBQ=URL=fpdb/Dan.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] Too many fields defined.
::
:: Source: Microsoft OLE DB Provider for ODBC Drivers
:: Number: -2147467259 (0x80004005)
::: -----Original Message-----
::: 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.net-sites.com/sitebuilder/newsgroups.asp
::: _____________________________________________
:::
:::
:: in message :::: I am trying to set a form to post to an excel db, Is
:: this
:::: possibe? If so, what connection string is required and
:::: what do I need to set in the form/excel properties to
:::: allow the db to be written to? thanks
:::
:::
::: .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
Word macro that can call cells out of Excel for a find and replace 0
Excel --> Word 4
Embed the same Excel multiple times 0
Autonumber field in Excel that behaves the same as Access 0
Need Help with Macro Security 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Using Office Forms and dynamically updating the excel backend 0

Top