I am trying to get the data from several rows of a data table into a single cell. How can I do that? The table below in my code contains a single column and multiple records. I would like to get all the records into one cell and have the cell size vertically to accomodate the records. When I try the code below the data starts in the specified cell but there is a record in each cell below it. For example, if there are 3 records in the table, they populate cells E5 thru G5. I want all 3 records to end up in Cell E5 stacked vertically. How can that be done?
MyAdapter.Fill(SelTable)
worksheet.Cells.ImportDataTable(SelTable, True, "E5")
worksheet.AutoFitColumns()
Thanks...