writeXmlSchema to MS-Access

  • Thread starter Thread starter Nicolas
  • Start date Start date
N

Nicolas

Hi, I would like to know how should I proceed for the following

I got a dataset and datatable from SQL database displayed in a datagrid
How do I create a Table now in MS_Access base on my Table displayed

Like I want to export this datagrid table design and data to an ms-access
database

I will have previously create a blank database in my bin folder

Thank for your help.

Nicolas
 
Nicolas said:
Hi, I would like to know how should I proceed for the following

I got a dataset and datatable from SQL database displayed in a datagrid
How do I create a Table now in MS_Access base on my Table displayed

Like I want to export this datagrid table design and data to an ms-access
database

I will have previously create a blank database in my bin folder
Click to expand...

Hi Nicolas,

Creating Access-databases is possible with ADOX.
http://support.microsoft.com/?scid=317867

Creating tables in Access-Databases:
http://support.microsoft.com/?scid=252908

You might create a column in Access for each column in your DataGrid and
export the data afterwards.

Cheers

Arne Janning
 
Back
Top