Hi Experts,
I have create a schema, i.e. "schema1" and grant all permissions to specific user.
This schema will be used to store the service a/r invoice that created by using my other application that used mysql database.
The application will send the a/r invoice data in the excel file on daily basis . I would import the excel schema is stored in the ar_inv table. The data is imported to this schema using VB.net 2010. Is it possible to do this ?
Can you share a certain sample to do this ? I even plan to import directly from mysql and then imported the data to the schema1. is it possible too ? Appreciate your answers so much.
Rgds,
Steve