468,727 Members | 1,668 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,727 developers. It's quick & easy.

Dataset -> XML -> Access .adp file

Good morning everyone,

Using C# I create a bog-standard System.Data.DataTable
which I then Add to a System.Data.Dataset.

I need to import that structure into an Access .adp file
so I have taken the approach of using XmlTextWriter to
create an xml file. This works just fine and the IDE can
certainly read it back and interpret it correctly. But
Access cannot. It tells me that it cannot create table
using the information contained in the document.

If someone knows the details could you please tell me what
I need to do to make this happen. Clearly the VS C#
implementation and Access are meant to be able to
communicate through this mechanism and it seems that I
have chosen wrong settings for some factor somewhere.

The code I used to write the file (this come more or les
directly from the Help on XML) is:

private void WriteSchema()
string fn = @"C:\InfoMan\InfoData\mySchema.xml";

System.IO.FileStream fs =
new System.IO.FileStream(
fn,System.IO.FileMode.Create );

System.Xml.XmlTextWriter xw =
new System.Xml.XmlTextWriter( fs,
System.Text.Encoding.Unicode );

_DataSet.WriteXmlSchema( xw );

Thanks in advance for any advice you can give me,


Nov 15 '05 #1
0 1952

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Maury | last post: by
12 posts views Thread by facicad | last post: by
reply views Thread by mnor07 | last post: by
1 post views Thread by markliam | last post: by
3 posts views Thread by Zabooster | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.