importing excel data

[manishbhalshankar]

Hi,

On line (4), you have "Dir&ExcelName".
Does it mean that there are 2 variables where Dir has the location of the file and ExcelName has the file name?
If so try this:

Code:

Dir = "Complete path of your file\"
ExcelName = "ExcelName.xls"

DataTable.AddSheet("TestSheet")
DataTable.ImportSheet Dir & ExcelName, "sheetName", "TestSheet"

This is working for me.