Jump to content
Sign in to follow this  
swarooppal1088

Automate import of data from excel to DB via front end

Recommended Posts

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×