Click here to Skip to main content
15,851,915 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

1 solution

you can try this one..

VBScript to Load Excel Files In A Folder Into SQL Server 2000 table [^]

I think this will help you.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900