Could anybody tell me why, if I try to code an import procedure I get the the message "Unable to get table field descriptions", when I run it .What does this mean ? I have no problems doing the import manually.
The code for the procedure is as follows, it is on one line in the coding.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
The last parameter you have set to "true". This tells ObjectPAL to get the fieldnames from the first row. My first guess is that the first row of the spreadsheet is empty. If so, try setting the last parameter to False and see what happens.
We have found a way round the problem, as we are using aliases in the BDE, Our original code was thus, importspreadsheet(":filters:dailysales.xls",":filters:dailysales.db","a:a1","a:f65000",true) where :filters: is our alias.
This opens the alias, and allows us to open the spreadsheet, and by including :filters: in the second parameter, the .db is forced into the correct directory. The third and fourth parameter are "" so that it does not need a specific range,(we tried leaving this out completely, but we just got a syntax error).Then we set the last value to true, even though this is supposed to be the default, and therefore not required, we found the script would not work without it!
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
Might I refer you to a posting of mine dated 3/11/01 titled Importing Excel Spreadsheets. I have had the same problem as detailed above. My spreadsheet definitely does not have a blank row. PS. Your books are brilliant (I have several) and they are an invaluable resource. Will you be doing one for 10 or are there too few changes in the new version?