I am attempting to Import an Excel file with multiple sheets for each location. I ask the user to select the location they want to import and using a lookup I load the variable VTabPage as an integer value with the Sheet Number
When I issue the command GATEWAY IMPORT XLS .vfilename CREATE &vtablename OPTION SHEET_INDEX .vtabpage|COLUMN_COUNT 5|FIRST_ROW 12 It spins for 5 seconds but nothing happens. If I issue the same command but put a number in the Sheet Index, it works (GATEWAY IMPORT XLS .vfilename CREATE &vtablename OPTION SHEET_INDEX 5|COLUMN_COUNT 5|FIRST_ROW 12) I am sure I am missing something here.. Blues Clues anyone ? Thanks Frank Taylor - Director of Information Technology F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 Email: [email protected]
