ODBC Excel Driver Error..

[Phoon]

I am facing the problem when I try to create
the cystal report. I am creating the VB
program that will run the output in crystal
report format by pulling the data source
from excel database.

But every time after I restarting the PC,
the same error will occur and the crystal
report will be coruppted. The error message
is:-
ODBC error:[Microsoft][ODBC Excel Driver]
Too few parameters. Expected 3
Then the second error will also come out
that is:-
Error detected by database DLL

The VB program that I used is VB 6.0,the
version of the ODBC is 4.0.41103.2 and the version of excel is 1997-2000.

Can somebody give me some solution to solve
this problem. Urgent!

Thanks,
Phoon
06/26/2001

 

[Cagliostro]

I think you need the VB forum. John Fill

ivfmd@mail.md