Excel Import - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

Ajeethk
No customer Topic Starter

2014-09-23T13:48:02Z

Hi Team,

We have a requirement to import files using Visual Cron.

How do I read data from and Excel or CSV file as Task1 and then access the columns to provide it as part of Insert statement in SQL Task 2.

Thanks,
Ajeeth

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

al355
No customer

2014-09-24T15:47:51Z

I would suggest using SQL bulk copy for this, we do this in several jobs. Visual Cron doesn't really do anything with the data.