[AccessD] Importing XML into a database

I looked but did not find a way for the ADO stuff to just persist a table
that is in a data set but not in SQL Server.  Is there such a thing or will
I need to build up a sql statement to execute to do this? 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Monday, October 08, 2007 2:55 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Importing XML into a database

<<<
Somehow the table has to be created in SQL Server first?
>>>
Yes.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, October 08, 2007 12:43 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Importing XML into a database

Shamil,

The code line :

adapter.Update(ds, className)

Is throwing an exception "Deferred prepare could not be completed.
Statement(s) could not be prepared.
Invalid object name 'tlbLog'."

tblLog does NOT exist yet in SQL Server and so an update is probably not
legal.  Somehow the table has to be created in SQL Server first?

John W. Colby
Colby Consulting
www.ColbyConsulting.com