how to Create access table from Datatable

[Kaustubh Patil]

I have a datatable filled by executing a query on SQL server.
Now I need to add these records in the access database. Before adding records, I need to create the table in access database depending on the datatable schema.How do I procced?
Please help.......

[danp129]

Get the column data types from your datatable

myDataTable.Columns(0).DataType.ToString()

Then create your tables using SQL statements in access using the closest equivalent type that doesn't cause any errors.