Re: Build new Access database from .NET application.

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 07/30/04


Date: Fri, 30 Jul 2004 13:49:53 -0500

On Fri, 30 Jul 2004 17:16:01 +0200, "Cor Ligthert" <notfirstname@planet.nl> wrote:

¤ Paul,
¤
¤ When you start in the top of the thread you can see that his goal was to
¤ create the access database from new, slowly we got at a point where we had
¤ everything however not the starting goal what was creating in a simple way
¤ the access database from XSD and I was hoping you was providing that.
¤
¤ Cor

Like he said, he was able to create the database and table using the XSD. The data import/export
method could be accomplished a few different ways. The first is to use the example I provide which
implements XML. Another would be to programmatically link the SQL Server table to the Access
database and then use an INSERT (Append) query to import the data into the Access table directly.

Since he wants to export from a DataGrid the direct method would not be possible.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)



Relevant Pages

  • Re: Jet Database Wont Open
    ... Paul did in ... to create the connection string and to create a Dataset. ... is stored in an Access database. ... When I use the DataAdaptor to preview the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: dev connections work, test does not
    ... Hi, Paul: ... Then, because the app was failing on my test box, I thought I'd try another way, hence my efforts with odbc. ... It seems to be connecting to connection information somewhere that doesn't relate to the application. ... Can I assume that the login dialog is for the Access database and not for a linked table to another ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Merging tables when PK values are same for SOME records
    ... Paul, thanks for the suggestion. ... Here's a newb question for you: what do you mean by "create a linked ... > server to the access database. ...
    (microsoft.public.sqlserver.replication)
  • Re: pocketaccess synchronization with windows mobile 5.0
    ... Paul T. ... >I would like to synchronize an Access database with windowsw mobile 5.0 ...
    (microsoft.public.pocketpc.activesync)