PCMech Forums - View Single Post - VB

dallandra · 07-10-2000, 10:58 PM

Hi all,

Just trying to create a simple prog. via the data-form-wizard supplied with VB6 enterprise Ed.
My problem is this: I'm trying to link a database (the database file is in MS Excel format - and not MS ACCESS hence the link is established with OBDC) via an ADOBC data control icon to a Data Grid object.
The problem is that after filling in the required fields, and running the program, i find that a msg box error pops up with the msg (along the lines of...) 'record source name not found'.
I'm using the following SQL statement to retrieve the d/b: Select * from filename

where filename is the name of the file, and also the name of the "sheet" in MS EXCEL

any ideas anyone??

thanks in advance!

07-10-2000, 10:58 PM	#1
dallandra Member (3 bit) Join Date: Jul 2000 Posts: 4	Hi all, Just trying to create a simple prog. via the data-form-wizard supplied with VB6 enterprise Ed. My problem is this: I'm trying to link a database (the database file is in MS Excel format - and not MS ACCESS hence the link is established with OBDC) via an ADOBC data control icon to a Data Grid object. The problem is that after filling in the required fields, and running the program, i find that a msg box error pops up with the msg (along the lines of...) 'record source name not found'. I'm using the following SQL statement to retrieve the d/b: Select * from filename where filename is the name of the file, and also the name of the "sheet" in MS EXCEL any ideas anyone?? thanks in advance!