*
* Never mind, i just tell it that its an excel 5 type and it works anyway
*
hi all,
I am trying to import information from an excel file. i ask the user to select the file and then copy a table structure to a temp cursor while doing checking on the information and finally actually adding it to the main table. The problem is that the user will now be sending information on 4 sheets in excel 2000 or better and unless i get them to save the file as excel type 5 i can't reference the sheets. i am sure that there has to be a work around but i just can't get it, any one point me in the right direction please.
Slán
~M
Go raibh maith agat
~M