I'm no expert, but can read - and understand some vbscript.
I need the following.
a function to call that will perform the following.
1. pass the file location to the function.
2. open the exel object and
3. retrieve the excel data from a specific range i.e. reng(A1:AZ100)
4. for each row within the excel sheet to be inserted into a database table.
could anyone assist me please