Toad World® Forums

Problem with Automated import from Excel


#1

TDA v2.6

Have had a *.tas working fine for some time.

Today trying to import 14K+ records from Excel. Have never imported more than a couple hundred prior to today.

First attempts I received message “attempting to import 2500 rows”; “successfully imported 2499 rows”; then “failed”.

Only setting I could see to change was “processing row count”. I bumped this to 15,000 or so.

Import after that message “attempted to import 14636 rows”; “successfully imported 3997”; then “Failed”.

14,636 is the # of rows in my Excel file so my change appeared to help but not totally.

There was an automation message "Quest.Toad.Workflow.Activities.Database.ImportWizardActivity.Execute(ActivityExecutionContext executioncontext) just prior to the failed message.

Any thoughts?

Thanks.


#2

Disregard. Had a rogue field value. Thanks.