Posted by Grant Foraker on February 16, 2006 at 12:34:37: Uploaded files: 1
Trying to do an ODBC import from Excel. Did one a year ago and not since. Started with all 22 rows (A-V). Named "space: in Excel is from A1:V1151. The "field" names are in row 1.
I'm getting an error from the SELECT. "Too few parameters. Expected 5. in rsOpen:SELECT NASSN,NMEMNO,ELEGAL,ELEGAL2,EFNAME,E"
The CMD$ contains - "rsOpen:SELECT NASSN,NMEMNO,ELEGAL,ELEGAL2,EFNAME,ELNAME,EBAL,EOESCROW,EESCROW,EPADDR,EPNBR,EPSTREET,EPCITY,EPSTATE,EPZIP,EPZX FROM Members ORDER BY NASSN"
Wrote the CMD$ into the attached TXT file before sending the SELECT to ODBC and the error message received back.
I've tried reducing the number of "fields" in the SELECT and only the "Expected n" changes.