bit confusing.. as data table is equivalent to excel file while datasheet is equivalent to a sheet in excel. so you cannot put datatable to a datasheet.
At runtime you can export the data table
you can import any sheet from local system to global sheet by
importsheet method.
At runtime you can export the data table
Code:
DataTable.Export("file path\filename.xls")you can import any sheet from local system to global sheet by
importsheet method.