> >That would be my interpretation of the error as well, > however the sheet > >only has 1 column and that column has only 2956 records. > > > >Any other ideas? > > > > > Still sounds like that is the problem. Although when you > look at the spreadsheet it only has one column with data in > it, excel has a nasty habit of saying all these x columns are > actually in the spreadsheet, but empty.
Sorry, I wasn't clear enough, my bad. The sheet only has 1 column, all the other columns have been deleted, they are not empty, they are gone. > I can't remember exactly how the excel jdbc connector works, > but couldn't you do a select COLUMN from spreadsheet, rather > than select * from spreadsheet? Unfortunately not, the format of the spreadsheet changes with great regularity so the first query does a select *, then presents the column names to the user for identification, this is really the only option because barcode could be expressed as bc, barcode, bar code, bcode, EAN, UPC, or any one of many other names, same goes for catalogue number (cat. No., cat number, etc...), title, etc... > Do you really need it to be an excel spreadsheet? If this is > part of a manual process, can you save it out as a CSV and > use that instead? Unfortunately they come in to our computer illiterate staff as excel files, it is all I can do to teach them how to use a browse button, trying to get them to change to file format is not really an option. -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
