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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Creating report in VB6
- Thread starter nathan03
- Start date
-
- Tags
- datareport excel 2007 vb6
Similar threads
- Question
- Question
- Solved
