Creating & Calling Subroutines
We have to upload 4 different excel sheets to one database table. I have already uploaded the fields of 1 excel sheet by writing the code for that. Plz tell me how to upload the other three excel sheets ie. how to write a code to call a subroutine.
just write the code that you wrote to uplaod a file in a
FORM upload_table using filename startrow endrow startcol endcol. ..... *your code ENDFORM. and then call it using perform upload_table using: 'C:sample.xls' 1 100 1 2, 'C:sample1.xls' 1 100 1 2, 'C:sample2.xls' 1 100 1 2.