Hi,
I'm trying to use "transferspreadsheet" to bring in an excel spreadsheet and insert it into a table. It works, but sometimes the spreadsheet may have multiple sheets.
Is there a way to not import all the sheets in a spread sheet? It would be great if I could set up a prompt to ask which sheet to import.

Thanks for any help,

David

Not exactly sure what you're getting at - are you bringing in an existing Excel sheet or a new sheet? On the server save an Excel workbook with one sheet in it on as a template. In your code do a FILECOPY to put the wkbk on a user's computer, and the TRANSFERSPREADSHEET. If you are trying to open up a new Excel workbook for some reason, it will show up with three sheets unless you change the setting in Excel's Options - General tab.

Jeff Stubing

Well, I've already found a way around this. What I was asking about was the TransferSpreadsheet method.
I was trying to find a way to import an excel workbook which had 5 or 6 different sheets. It was only bringing in the first sheet when I tried to import it and I wanted all the sheets.