# Toad Sql Server Import Wizard - difference seen in the rows loaded msg versus actual number of rows in table

**URL:** <https://forums.toadworld.com/t/toad-sql-server-import-wizard-difference-seen-in-the-rows-loaded-msg-versus-actual-number-of-rows-in-table/39440>\
**Category:** Toad for SQL Server\
**Created:** [May 9, 2017, 7:17am UTC](https://forums.toadworld.com/t/toad-sql-server-import-wizard-difference-seen-in-the-rows-loaded-msg-versus-actual-number-of-rows-in-table/39440 "2017-05-09T07:17:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sherlyn.divya](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sherlyn.divya](https://forums.toadworld.com/u/sherlyn.divya)\
**Post date:** [May 9, 2017, 7:17am UTC](https://forums.toadworld.com/t/toad-sql-server-import-wizard-difference-seen-in-the-rows-loaded-msg-versus-actual-number-of-rows-in-table/39440/1 "2017-05-09T07:17:59Z")

</div>

I’m using Toad Import wizard to load a csv file into a Sql server table. When I do smaller loads it works fine and it has always worked fine, but this time my file is large. I imported the file and the wizard said 1.9M rows have been loaded but when I look at the table it has only 1.3M rows. There are no errors on the log file, there are no triggers on the table, no space issues, nor any transformations that I’m applying during the load. Any reason or thoughts on why this difference in numbers between what toad tells me its loaded versus the actual number in the table?

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\
**Post date:** [May 22, 2017, 6:32pm UTC](https://forums.toadworld.com/t/toad-sql-server-import-wizard-difference-seen-in-the-rows-loaded-msg-versus-actual-number-of-rows-in-table/39440/2 "2017-05-22T18:32:05Z")

</div>

Hi sherlyn.divya,

Have you try to 64bit Toad for SQL Server ?

when you import a large file about 1.9M rows, it was easy to get out of memory.

Michael

---

<div class="post-metadata">

**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\
**Post date:** [May 22, 2017, 6:38pm UTC](https://forums.toadworld.com/t/toad-sql-server-import-wizard-difference-seen-in-the-rows-loaded-msg-versus-actual-number-of-rows-in-table/39440/3 "2017-05-22T18:38:21Z")

</div>

and you can try v6.8 64bit beta from : [www.toadworld.com/…/](http://www.toadworld.com/products/toad-for-sql-server/toad_for_sql_server_beta_program/)