Related Tips & Info

What can cause the SilkTest error " *** Error: (07002) [Microsoft][ODBC Excel Driver] Too few parameters. Expected " ?

MigrationDeletedUser
0 Likes

If you have already checked the SQL syntax What causes the SilkTest error " *** Error: (07002) [Microsoft][ODBC Excel Driver] Too few parameters. Expected " ? and are still getting this error then check to see if any of the Excel "column header names", have spaces " " in them.

If there are spaces present, then you could consider removing them i.e. edit the Excel file to get rid of the spaces. Alternatively the spaces could be replaced with the underscore character "_".

Old KB# 22068
Comment List
Related
Recommended

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.