Dataset to Access DB

How can I insert all records from a DataSet to an Access Table.

Thanks

William
Mon Apr 26 20:55:51 CDT 2004

It depends on how you got those records there. If the Rowstate of each row
is "Added" then all you need to do is provide a valid Insert command to your
dataadapter and call the .Update method of the adapter. So, if you are
filling it from another table in this db or another db, then when you call
DataAdapter.Fill from the original adapter, set the .AcceptChangesDuringFill
property to false. This will cause all of the records inserted to have a
rowstate or Added. Then call .Update with an adapter who's update command
is pointing to the destination table, and they'll all be inserted.
http://www.knowdotnet.com/articles/datasetmerge.html

Otherwise, you may need to take a different approach. If whatever approach
you used (like manually adding the rows) cause the Rowstate to be added, the
same will hold true. Otherwise, you may have to loop through the Dataset,
and use the values as paramaters for an insert statement or use the values
to manually build an insert statement, then calling executeNonQuery. By far
calling update is the easisest. You can check if the dataset has changes
via DataSet.HasChanges and if so, let me know what the rowstate is if it's
not added, I'll walk you through the second approach I mentioned here.

HTH,

Bill
"T Cordon" <tcordonb@hotmail.com> wrote in message
news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> How can I insert all records from a DataSet to an Access Table.
>
> Thanks
>
>

Val
Mon Apr 26 22:50:05 CDT 2004

Hi,

Next Kb shows an example. Even though it is for SQL Server, you will get an
idea how to do this. You will need to use Oledb .NET Managed provider
instead of SQL Server one, but rest of staff is basically the same

http://support.microsoft.com/default.aspx?scid=kb;en-us;308055&Product=adonet

--
Val Mazur
Microsoft MVP


"T Cordon" <tcordonb@hotmail.com> wrote in message
news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> How can I insert all records from a DataSet to an Access Table.
>
> Thanks
>
>

T
Tue Apr 27 00:11:10 CDT 2004

Hi, Thanks for your repply.

It seems to be pointing me to the right direction but I just can't get it to
work.

What I am trying to to is to update an Access DB using a web service. So int
the local App (WinForms - VB) I get all the tables in the database, and for
earch one, fill a dataset that I send to the webservice. The structure of
the DB is exactly the same in both places. The web service is supposed to
get the dataset and and table name, drop all current records and insert all
the records it got from the dataset it received.

Any help is greatly appreciated.

Thanks Again.


"William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
news:O533Ar$KEHA.2556@TK2MSFTNGP11.phx.gbl...
> It depends on how you got those records there. If the Rowstate of each
row
> is "Added" then all you need to do is provide a valid Insert command to
your
> dataadapter and call the .Update method of the adapter. So, if you are
> filling it from another table in this db or another db, then when you call
> DataAdapter.Fill from the original adapter, set the
.AcceptChangesDuringFill
> property to false. This will cause all of the records inserted to have a
> rowstate or Added. Then call .Update with an adapter who's update command
> is pointing to the destination table, and they'll all be inserted.
> http://www.knowdotnet.com/articles/datasetmerge.html
>
> Otherwise, you may need to take a different approach. If whatever approach
> you used (like manually adding the rows) cause the Rowstate to be added,
the
> same will hold true. Otherwise, you may have to loop through the Dataset,
> and use the values as paramaters for an insert statement or use the values
> to manually build an insert statement, then calling executeNonQuery. By
far
> calling update is the easisest. You can check if the dataset has changes
> via DataSet.HasChanges and if so, let me know what the rowstate is if it's
> not added, I'll walk you through the second approach I mentioned here.
>
> HTH,
>
> Bill
> "T Cordon" <tcordonb@hotmail.com> wrote in message
> news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > How can I insert all records from a DataSet to an Access Table.
> >
> > Thanks
> >
> >
>
>

Cor
Tue Apr 27 02:23:43 CDT 2004

Hi T Cordon,

What I always call the best walkthrough I know on MSDN.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vbwlkCreatingDistributedWebApplicationWalkthrough.asp

I hope this helps a little bit?

Cor

T
Tue Apr 27 03:34:50 CDT 2004

Thank you all. Got it working... sort of. Just getting this error sometimes:

Additional information: System.Web.Services.Protocols.SoapException: There
was an exception running the extensions specified in the config file. --->
System.Web.HttpException: Maximum request length exceeded.
at System.Web.HttpRequest.GetEntireRawContent()
at System.Web.HttpRequest.get_InputStream()
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
--- End of inner exception stack trace ---

Any Ideas?

Thanks



"Val Mazur" <group51a@hotmail.com> wrote in message
news:%23j6v5qALEHA.3016@tk2msftngp13.phx.gbl...
> Hi,
>
> Next Kb shows an example. Even though it is for SQL Server, you will get
an
> idea how to do this. You will need to use Oledb .NET Managed provider
> instead of SQL Server one, but rest of staff is basically the same
>
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;308055&Product=adonet
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "T Cordon" <tcordonb@hotmail.com> wrote in message
> news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > How can I insert all records from a DataSet to an Access Table.
> >
> > Thanks
> >
> >
>
>

William
Tue Apr 27 08:10:16 CDT 2004

T:

Does the web service automatically infer that it's going to insert
everything (ie the update logic is such that it doesn't use Rowstate to
insert the rows, it just loops through them and adds them no matter what)?
Or does it depend on Rowstate?
"T Cordon" <tcordonb@hotmail.com> wrote in message
news:uwVbOYBLEHA.3016@tk2msftngp13.phx.gbl...
> Hi, Thanks for your repply.
>
> It seems to be pointing me to the right direction but I just can't get it
to
> work.
>
> What I am trying to to is to update an Access DB using a web service. So
int
> the local App (WinForms - VB) I get all the tables in the database, and
for
> earch one, fill a dataset that I send to the webservice. The structure of
> the DB is exactly the same in both places. The web service is supposed to
> get the dataset and and table name, drop all current records and insert
all
> the records it got from the dataset it received.
>
> Any help is greatly appreciated.
>
> Thanks Again.
>
>
> "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> news:O533Ar$KEHA.2556@TK2MSFTNGP11.phx.gbl...
> > It depends on how you got those records there. If the Rowstate of each
> row
> > is "Added" then all you need to do is provide a valid Insert command to
> your
> > dataadapter and call the .Update method of the adapter. So, if you are
> > filling it from another table in this db or another db, then when you
call
> > DataAdapter.Fill from the original adapter, set the
> .AcceptChangesDuringFill
> > property to false. This will cause all of the records inserted to have
a
> > rowstate or Added. Then call .Update with an adapter who's update
command
> > is pointing to the destination table, and they'll all be inserted.
> > http://www.knowdotnet.com/articles/datasetmerge.html
> >
> > Otherwise, you may need to take a different approach. If whatever
approach
> > you used (like manually adding the rows) cause the Rowstate to be added,
> the
> > same will hold true. Otherwise, you may have to loop through the
Dataset,
> > and use the values as paramaters for an insert statement or use the
values
> > to manually build an insert statement, then calling executeNonQuery. By
> far
> > calling update is the easisest. You can check if the dataset has
changes
> > via DataSet.HasChanges and if so, let me know what the rowstate is if
it's
> > not added, I'll walk you through the second approach I mentioned here.
> >
> > HTH,
> >
> > Bill
> > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > How can I insert all records from a DataSet to an Access Table.
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

T
Tue Apr 27 09:18:17 CDT 2004

It just inserts everything. Tables are cleared previous to this.


"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:e5sQehFLEHA.3664@TK2MSFTNGP10.phx.gbl...
> T:
>
> Does the web service automatically infer that it's going to insert
> everything (ie the update logic is such that it doesn't use Rowstate to
> insert the rows, it just loops through them and adds them no matter what)?
> Or does it depend on Rowstate?
> "T Cordon" <tcordonb@hotmail.com> wrote in message
> news:uwVbOYBLEHA.3016@tk2msftngp13.phx.gbl...
> > Hi, Thanks for your repply.
> >
> > It seems to be pointing me to the right direction but I just can't get
it
> to
> > work.
> >
> > What I am trying to to is to update an Access DB using a web service. So
> int
> > the local App (WinForms - VB) I get all the tables in the database, and
> for
> > earch one, fill a dataset that I send to the webservice. The structure
of
> > the DB is exactly the same in both places. The web service is supposed
to
> > get the dataset and and table name, drop all current records and insert
> all
> > the records it got from the dataset it received.
> >
> > Any help is greatly appreciated.
> >
> > Thanks Again.
> >
> >
> > "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> > news:O533Ar$KEHA.2556@TK2MSFTNGP11.phx.gbl...
> > > It depends on how you got those records there. If the Rowstate of
each
> > row
> > > is "Added" then all you need to do is provide a valid Insert command
to
> > your
> > > dataadapter and call the .Update method of the adapter. So, if you
are
> > > filling it from another table in this db or another db, then when you
> call
> > > DataAdapter.Fill from the original adapter, set the
> > .AcceptChangesDuringFill
> > > property to false. This will cause all of the records inserted to
have
> a
> > > rowstate or Added. Then call .Update with an adapter who's update
> command
> > > is pointing to the destination table, and they'll all be inserted.
> > > http://www.knowdotnet.com/articles/datasetmerge.html
> > >
> > > Otherwise, you may need to take a different approach. If whatever
> approach
> > > you used (like manually adding the rows) cause the Rowstate to be
added,
> > the
> > > same will hold true. Otherwise, you may have to loop through the
> Dataset,
> > > and use the values as paramaters for an insert statement or use the
> values
> > > to manually build an insert statement, then calling executeNonQuery.
By
> > far
> > > calling update is the easisest. You can check if the dataset has
> changes
> > > via DataSet.HasChanges and if so, let me know what the rowstate is if
> it's
> > > not added, I'll walk you through the second approach I mentioned here.
> > >
> > > HTH,
> > >
> > > Bill
> > > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > > How can I insert all records from a DataSet to an Access Table.
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>
>

William
Tue Apr 27 09:39:18 CDT 2004

I just saw your other post, so it's essentially fixed but that one
exception?
"T Cordon" <tcordonb@hotmail.com> wrote in message
news:OWOA8JGLEHA.1348@TK2MSFTNGP12.phx.gbl...
> It just inserts everything. Tables are cleared previous to this.
>
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:e5sQehFLEHA.3664@TK2MSFTNGP10.phx.gbl...
> > T:
> >
> > Does the web service automatically infer that it's going to insert
> > everything (ie the update logic is such that it doesn't use Rowstate to
> > insert the rows, it just loops through them and adds them no matter
what)?
> > Or does it depend on Rowstate?
> > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > news:uwVbOYBLEHA.3016@tk2msftngp13.phx.gbl...
> > > Hi, Thanks for your repply.
> > >
> > > It seems to be pointing me to the right direction but I just can't get
> it
> > to
> > > work.
> > >
> > > What I am trying to to is to update an Access DB using a web service.
So
> > int
> > > the local App (WinForms - VB) I get all the tables in the database,
and
> > for
> > > earch one, fill a dataset that I send to the webservice. The structure
> of
> > > the DB is exactly the same in both places. The web service is supposed
> to
> > > get the dataset and and table name, drop all current records and
insert
> > all
> > > the records it got from the dataset it received.
> > >
> > > Any help is greatly appreciated.
> > >
> > > Thanks Again.
> > >
> > >
> > > "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> > > news:O533Ar$KEHA.2556@TK2MSFTNGP11.phx.gbl...
> > > > It depends on how you got those records there. If the Rowstate of
> each
> > > row
> > > > is "Added" then all you need to do is provide a valid Insert command
> to
> > > your
> > > > dataadapter and call the .Update method of the adapter. So, if you
> are
> > > > filling it from another table in this db or another db, then when
you
> > call
> > > > DataAdapter.Fill from the original adapter, set the
> > > .AcceptChangesDuringFill
> > > > property to false. This will cause all of the records inserted to
> have
> > a
> > > > rowstate or Added. Then call .Update with an adapter who's update
> > command
> > > > is pointing to the destination table, and they'll all be inserted.
> > > > http://www.knowdotnet.com/articles/datasetmerge.html
> > > >
> > > > Otherwise, you may need to take a different approach. If whatever
> > approach
> > > > you used (like manually adding the rows) cause the Rowstate to be
> added,
> > > the
> > > > same will hold true. Otherwise, you may have to loop through the
> > Dataset,
> > > > and use the values as paramaters for an insert statement or use the
> > values
> > > > to manually build an insert statement, then calling executeNonQuery.
> By
> > > far
> > > > calling update is the easisest. You can check if the dataset has
> > changes
> > > > via DataSet.HasChanges and if so, let me know what the rowstate is
if
> > it's
> > > > not added, I'll walk you through the second approach I mentioned
here.
> > > >
> > > > HTH,
> > > >
> > > > Bill
> > > > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > > > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > > > How can I insert all records from a DataSet to an Access Table.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

T
Tue Apr 27 09:58:58 CDT 2004

Yes, and it always happens in the same Table ??? I don't get it


"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:OvHvOTGLEHA.1032@tk2msftngp13.phx.gbl...
> I just saw your other post, so it's essentially fixed but that one
> exception?
> "T Cordon" <tcordonb@hotmail.com> wrote in message
> news:OWOA8JGLEHA.1348@TK2MSFTNGP12.phx.gbl...
> > It just inserts everything. Tables are cleared previous to this.
> >
> >
> > "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> > news:e5sQehFLEHA.3664@TK2MSFTNGP10.phx.gbl...
> > > T:
> > >
> > > Does the web service automatically infer that it's going to insert
> > > everything (ie the update logic is such that it doesn't use Rowstate
to
> > > insert the rows, it just loops through them and adds them no matter
> what)?
> > > Or does it depend on Rowstate?
> > > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > > news:uwVbOYBLEHA.3016@tk2msftngp13.phx.gbl...
> > > > Hi, Thanks for your repply.
> > > >
> > > > It seems to be pointing me to the right direction but I just can't
get
> > it
> > > to
> > > > work.
> > > >
> > > > What I am trying to to is to update an Access DB using a web
service.
> So
> > > int
> > > > the local App (WinForms - VB) I get all the tables in the database,
> and
> > > for
> > > > earch one, fill a dataset that I send to the webservice. The
structure
> > of
> > > > the DB is exactly the same in both places. The web service is
supposed
> > to
> > > > get the dataset and and table name, drop all current records and
> insert
> > > all
> > > > the records it got from the dataset it received.
> > > >
> > > > Any help is greatly appreciated.
> > > >
> > > > Thanks Again.
> > > >
> > > >
> > > > "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> > > > news:O533Ar$KEHA.2556@TK2MSFTNGP11.phx.gbl...
> > > > > It depends on how you got those records there. If the Rowstate of
> > each
> > > > row
> > > > > is "Added" then all you need to do is provide a valid Insert
command
> > to
> > > > your
> > > > > dataadapter and call the .Update method of the adapter. So, if
you
> > are
> > > > > filling it from another table in this db or another db, then when
> you
> > > call
> > > > > DataAdapter.Fill from the original adapter, set the
> > > > .AcceptChangesDuringFill
> > > > > property to false. This will cause all of the records inserted to
> > have
> > > a
> > > > > rowstate or Added. Then call .Update with an adapter who's update
> > > command
> > > > > is pointing to the destination table, and they'll all be inserted.
> > > > > http://www.knowdotnet.com/articles/datasetmerge.html
> > > > >
> > > > > Otherwise, you may need to take a different approach. If whatever
> > > approach
> > > > > you used (like manually adding the rows) cause the Rowstate to be
> > added,
> > > > the
> > > > > same will hold true. Otherwise, you may have to loop through the
> > > Dataset,
> > > > > and use the values as paramaters for an insert statement or use
the
> > > values
> > > > > to manually build an insert statement, then calling
executeNonQuery.
> > By
> > > > far
> > > > > calling update is the easisest. You can check if the dataset has
> > > changes
> > > > > via DataSet.HasChanges and if so, let me know what the rowstate is
> if
> > > it's
> > > > > not added, I'll walk you through the second approach I mentioned
> here.
> > > > >
> > > > > HTH,
> > > > >
> > > > > Bill
> > > > > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > > > > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > > > > How can I insert all records from a DataSet to an Access Table.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

T
Tue Apr 27 10:18:10 CDT 2004

I get this in while trying to transfer the largest table DataSet, about 6000
records.

Thanks for your help


"T Cordon" <tcordonb@hotmail.com> wrote in message
news:ugttBKDLEHA.3596@tk2msftngp13.phx.gbl...
> Thank you all. Got it working... sort of. Just getting this error
sometimes:
>
> Additional information: System.Web.Services.Protocols.SoapException: There
> was an exception running the extensions specified in the config file. --->
> System.Web.HttpException: Maximum request length exceeded.
> at System.Web.HttpRequest.GetEntireRawContent()
> at System.Web.HttpRequest.get_InputStream()
> at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
> --- End of inner exception stack trace ---
>
> Any Ideas?
>
> Thanks
>
>
>
> "Val Mazur" <group51a@hotmail.com> wrote in message
> news:%23j6v5qALEHA.3016@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Next Kb shows an example. Even though it is for SQL Server, you will get
> an
> > idea how to do this. You will need to use Oledb .NET Managed provider
> > instead of SQL Server one, but rest of staff is basically the same
> >
> >
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;308055&Product=adonet
> >
> > --
> > Val Mazur
> > Microsoft MVP
> >
> >
> > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > How can I insert all records from a DataSet to an Access Table.
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

William
Tue Apr 27 10:24:43 CDT 2004

HOw big is the data... Look in machine.config and check out he
maxRequestLength attribute... if I remember correctl it's in httpRunTime
element.

Anyway, make this larger (may be trial and error unless you know the rough
size of the data you are transferring). If ti's the access db, it's pretty
easy to get ann esitmate of. To test it first, just try the original
approach, but change your fill query so you only pass 20 records. See if
that works. If so, this is almost certinaly the culprit. Either way, I'm
85% sure this is it if it's the only problem you are having now.
"T Cordon" <tcordonb@hotmail.com> wrote in message
news:ugttBKDLEHA.3596@tk2msftngp13.phx.gbl...
> Thank you all. Got it working... sort of. Just getting this error
sometimes:
>
> Additional information: System.Web.Services.Protocols.SoapException: There
> was an exception running the extensions specified in the config file. --->
> System.Web.HttpException: Maximum request length exceeded.
> at System.Web.HttpRequest.GetEntireRawContent()
> at System.Web.HttpRequest.get_InputStream()
> at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
> --- End of inner exception stack trace ---
>
> Any Ideas?
>
> Thanks
>
>
>
> "Val Mazur" <group51a@hotmail.com> wrote in message
> news:%23j6v5qALEHA.3016@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Next Kb shows an example. Even though it is for SQL Server, you will get
> an
> > idea how to do this. You will need to use Oledb .NET Managed provider
> > instead of SQL Server one, but rest of staff is basically the same
> >
> >
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;308055&Product=adone
t
> >
> > --
> > Val Mazur
> > Microsoft MVP
> >
> >
> > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > How can I insert all records from a DataSet to an Access Table.
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

T
Tue Apr 27 18:11:37 CDT 2004

Thank you all for your help!


"T Cordon" <tcordonb@hotmail.com> wrote in message
news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> How can I insert all records from a DataSet to an Access Table.
>
> Thanks
>
>

William
Tue Apr 27 23:18:29 CDT 2004

Did you get it to work?
"T Cordon" <tcordonb@hotmail.com> wrote in message
news:%23itK9zKLEHA.1388@TK2MSFTNGP09.phx.gbl...
> Thank you all for your help!
>
>
> "T Cordon" <tcordonb@hotmail.com> wrote in message
> news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > How can I insert all records from a DataSet to an Access Table.
> >
> > Thanks
> >
> >
>
>

T
Wed Apr 28 09:38:58 CDT 2004

Yes, it works now. Had to change the maxRequestLength to a higher number
because a couple of table had ~ 70K records

But it worked.

I am now trying to optimize it and only send the new or modified records
comparing original DB table dataset with modified DB table Dataset so I can
send only those.

:)


"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:OtAOVfNLEHA.3056@TK2MSFTNGP12.phx.gbl...
> Did you get it to work?
> "T Cordon" <tcordonb@hotmail.com> wrote in message
> news:%23itK9zKLEHA.1388@TK2MSFTNGP09.phx.gbl...
> > Thank you all for your help!
> >
> >
> > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > How can I insert all records from a DataSet to an Access Table.
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

T
Wed Apr 28 21:21:03 CDT 2004

I'm getting one more error: Even when I do this with databases that have the
same structure in some tables I get this error:

-2147217900 Syntax error in INSERT INTO statemente.

Please need Help

Thanks


"T Cordon" <tcordonb@hotmail.com> wrote in message
news:eS%23KJ6SLEHA.2660@TK2MSFTNGP09.phx.gbl...
> Yes, it works now. Had to change the maxRequestLength to a higher number
> because a couple of table had ~ 70K records
>
> But it worked.
>
> I am now trying to optimize it and only send the new or modified records
> comparing original DB table dataset with modified DB table Dataset so I
can
> send only those.
>
> :)
>
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:OtAOVfNLEHA.3056@TK2MSFTNGP12.phx.gbl...
> > Did you get it to work?
> > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > news:%23itK9zKLEHA.1388@TK2MSFTNGP09.phx.gbl...
> > > Thank you all for your help!
> > >
> > >
> > > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > > How can I insert all records from a DataSet to an Access Table.
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>
>

T
Wed Apr 28 21:50:51 CDT 2004

The INSERT Statement is being generated by an OleDbCommandBuilder

Thanks

"T Cordon" <tcordonb@hotmail.com> wrote in message
news:%23VEVfCZLEHA.3052@TK2MSFTNGP12.phx.gbl...
> I'm getting one more error: Even when I do this with databases that have
the
> same structure in some tables I get this error:
>
> -2147217900 Syntax error in INSERT INTO statemente.
>
> Please need Help
>
> Thanks
>
>
> "T Cordon" <tcordonb@hotmail.com> wrote in message
> news:eS%23KJ6SLEHA.2660@TK2MSFTNGP09.phx.gbl...
> > Yes, it works now. Had to change the maxRequestLength to a higher number
> > because a couple of table had ~ 70K records
> >
> > But it worked.
> >
> > I am now trying to optimize it and only send the new or modified records
> > comparing original DB table dataset with modified DB table Dataset so I
> can
> > send only those.
> >
> > :)
> >
> >
> > "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> > news:OtAOVfNLEHA.3056@TK2MSFTNGP12.phx.gbl...
> > > Did you get it to work?
> > > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > > news:%23itK9zKLEHA.1388@TK2MSFTNGP09.phx.gbl...
> > > > Thank you all for your help!
> > > >
> > > >
> > > > "T Cordon" <tcordonb@hotmail.com> wrote in message
> > > > news:uuiZ8U$KEHA.2692@tk2msftngp13.phx.gbl...
> > > > > How can I insert all records from a DataSet to an Access Table.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>