New DataTable to Database

I have a ADO.NET DataTable created from an Excel Sheet.

I want this datatable to be inserted to an Access database. There is no table with the structure of the datatable in the database, so I need to add a completly new table into my Access database from the ADO.NET datatable. Can this be done?

I normally use a dataadapter to link a database to dataset/datatables, but since there are no tables present in the database, I don't know how to create an new table to recieve my datatable.

Thanx,
Jim

[527 byte] By [JimGordon] at [2007-12-26]
# 1

Yes...access uses a "Make Table" command when creating a table from imported data...

Excelent article on the subject:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/html/ExceltoAccess.asp

DMan1 at 2007-9-4 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

.NET Development

Site Classified