Automate import of data from excel to DB via front end

[swarooppal1088]

I have a task in which

1. i have a link which opens a gui with fileds to be filled taken from ana excel.

2. The excel has many columns and rows out which specific columns' data needs to be manuallu entered to the front end and den clicking on the save button enters the data to the DB.

3.There is no direct access to the DB.

4. I need to automate the process of loading as there are thousanda of rows in excel.

Please Help.

5.The front end is redbook (if of any help...)

Regards,

Swaroop

[swarooppal1088]

I have a task in which

1. i have a link which opens a gui with fileds to be filled taken from ana excel.

2. The excel has many columns and rows out which specific columns' data needs to be manuallu entered to the front end and den clicking on the save button enters the data to the DB.

3.There is no direct access to the DB.

4. I need to automate the process of loading as there are thousanda of rows in excel.

Please Help.

5.The front end is redbook (if of any help...)

Regards,

Swaroop

please consider it urgent and throw any suggestion it will be of some help

thanks

[Juvigy]

It should be possible.

1. Shellexecute() will start the "redbook" if it is local installation. IE UDF will help if it is online.

2. You can use Excel UDF to read the data from excel

3. ControlSend/ControlSet should help you set the data or IE UDF if it is online.

Thats all - doesnt seem very complicated.

[Zedna]

You will get more response if you post more information:

- use Au3Info or at least show some screenshot

- post XLS example and tell us what exactly do you need from it