DataSet Schema to MDB Table

[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.

 

[Cor Ligthert]

PJ,

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

Cor

 

[Cor Ligthert]

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