Mark,

Not quite clear what is the difference here between Excel5 and Excel2000. Both may contain several sheets, and you can use VFP import xl5 or (xl8) sheet "Sheetname" command to get the information from the particular sheet.
If you need to know in advance how many sheets there are and what are sheet names, then one of the ways is to use Excel automation and get the sheet names from there.



>*
>* 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