I develop an application in VB6 and my data source is Excel 2007. Now, I try to create DataReport. I could connect the excel file to VB. When I click the “Test connection” button in the Data Link Properties I receive the message “Test Connection Succeeded”. To fetch and put the data in the report, I added a Command and in the Command properties I selected Table as DataBase Object, but my excel file name is not in the Object Name. There are five columns in my Excel sheet and the 1st column is Serial number when the user select a serial number through a combo box in the form the other fields related to this should appear in the report. I need help, please.