DataSet Schema to MDB Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can iterate through a DataSet row-by-row to fill an MDB table, but how do I
apply only the schema of the DataSet to the MDB table without inserting any
data?

Thanks for your help.
 
PJ,

You cannot make from a dataset a MDB table. (It is possible from a datatable
however not from a dataset).

Cor
 
PJ,

I see that I answered already in a previous thread how to do that using
Create

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_8g9x.asp

To make that complete.

To get the columns you can loop through the columns from the datatable
for each col as datacolumn in ds.tables(0).columns
col.datatype gives the type
col.columname gives the columname
next

For eventualy needed lenghts have you of course to use defaults.

I hope this help

And please reply next time in the original thread.

Cor
 
Back
Top