Loading a dBase/Excel table into a GridView Control in ASP.NET 2.0
To load a dBase table using the AccessDataSource control use the following:
DataFile="data;extended properties=dBase IV"
SelectCommand="select * from [ACCOUNTS.dbf]"
To load an Excel worksheet using the AccessDataSource control use the following:
DataFile="data\ACCOUNTS.xls;extended properties=Excel 8.0"
SelectCommand="select * from [ACCOUNTS$]"