I have currently tried using Excel and the msquery wizard that comes with it. It has been relativley ok to use but now I'm expanding my queries into the database and attempting a parameter query by date. I keep getting a conversion error.
Here is the code generated, any input or help would be greatly appreciated.
INIH.INV stores dates in the form of MM/DD/YEAR
FROM INIH INIH