Toad World® Forums

Import Wizard from Excel - Error - wrong number of rows


#1

Using Excel import wizard encountered an error:

12:53:01 PM Thread (9) Importing 1 out of 1 files
12:53:01 PM Thread (9) Reading from file _Inventory.xlsx
12:53:01 PM Thread (9) Prepare the connection : SET DATEFORMAT YMD ; SET NOCOUNT OFF
12:53:09 PM Thread (9) Inserting row 500 into table BL_Database.dbo._Inventory
12:53:21 PM Thread (9) Inserting row 1000 into table BL_Database.dbo._Inventory
12:53:33 PM Thread (9) Inserting row 1500 into table BL_Database.dbo._Inventory
12:53:52 PM Thread (9) Continuing import regardless of the error: Error converting data type varchar to numeric.
12:53:53 PM Thread (9) Inserting row 2000 into table BL_Database.dbo._Inventory
12:54:05 PM Thread (9) Inserting row 2500 into table BL_Database.dbo._Inventory
12:54:16 PM Thread (9) Inserting row 3000 into table BL_Database.dbo._Inventory
12:54:27 PM Thread (9) Inserting row 3500 into table BL_Database.dbo._Inventory
12:54:39 PM Thread (9) Inserting row 3905 into table BL_Database.dbo._Inventory
12:54:48 PM Thread (9) 3905 rows from file _Inventory.xlsx were processed.
12:54:48 PM Thread (9) A total of 3904 out of 3905 rows were imported to table _Inventory.

12:55:05 PM Thread (9) Error(s) occured, 3904 out of 3905 rows were imported and have been committed.

12:55:05 PM Thread (9) Import Finished [04/01/2014 12:55:05 PM]
12:55:05 PM Thread (9) Import time: 00:02:04.5691250

But message says that 3904 of 3905 rows were imported.

But when I run this:

SELECT COUNT(*) FROM _Inventory

It returns 2405 records.

So why does the message say it successfully processed 3904?

Also, why doesn’t it return the actual row number it was processing when the error occurred?


#2

Hi Darren,

We can’t produce this. Please provide more information. Thank you.

Kelly

Email : kelly.chen@quest.com


#3

E-mailed you sample files directly.


#4

Try with these files.

Darren

From: Kelly.Chen [mailto:bounce-KellyChen@toadworld.com]
Sent: Thursday April 3, 2014 10:48 PM
To: toadssbeta@toadworld.com
Subject: RE: [Toad for SQL Server - Beta Discussion Forum] Import Wizard from Excel - Error - wrong number of rows

RE: Import Wizard from Excel - Error - wrong number of rows

Reply by Kelly.Chen

Hi Darren,

 We can't produce this. Please provide more information. Thank you.

Kelly

Email : kelly.chen@quest.com

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for SQL Server - Beta notifications altogether.
Toad for SQL Server - Beta Discussion Forum

Flag this post as spam/abuse.


#5

Unfortunately it looks like the original files I had that reproduce this error got overwritten. The current set of files I’m using do not produce this result anymore. If I can reproduce in future I’ll post again. For now the current set of raw data files I’m working with produce the correct number of rows imported when errors are skipped. You can close/ignore this issue for now.