Import data from excel to database

Hi,

How can i import data from excel to exiting table in sql DB.

Thanks,
Rithu

Hi,

You can use DataTable activity

Hi Amit,

I have used Data Table. Using ImportDataTable i have moved data from excel to data table but from DT to sql table how can i import?
I tried using Execute DB query. But there i need to explicitly specify the insert query.
Is there any other way i can import the complete data from excel to sql table?

Thanks,
Rithu

Hi,

Using Excel loop read the data
Then form an insert query
Post that use Execute DB Query activity to insert data

Regards,
Amit