Posted by Gerry Bennett (65.100.40.185) on September 19, 2003 at 16:15:00: Uploaded files: 2
We recently wanted to start excepting an EXCEL spreadsheet from different customers and input this information into a Comet database. We wanted to start simple so we picked up and used the sample program #XL from Signatures web site. We inserted our Excel file definitions into the #XL program and recompiled. I have atteched the source program(#XL) and the Excel spreadsheet(Employees).
The program basically gets to line 122, the READ (ODBC,EmployeeData) EXCP=EOF and immediately takes the EXCP branch. If we pull the EXCP out we get an Error 29 - "Communications line error".
We can't seem to see anything wrong with the program and we followed the documentation for "To create a named area in Excel".
Please take a look at this and let us know.
Thank you