sqlbulkcopy imports only 17837 out of 67000 rows

iis sqlbulkcopy

Question

When I deploy the sqlbulkcopy function to IIS, it only imports 17837 out of the 67K odd rows, despite the fact that it functions flawlessly in my local environment. Who has any idea what may be the problem?

1
0
1/23/2016 5:15:13 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Actually, the 'IMEX=1' at the very end of the Excel connection string was where the trouble lay. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:uploaded.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1' is the right connection string.

0
1/23/2013 4:09:57 PM

Related Questions

With the SqlBulkCopy class, you may import data from SQLite to SQL Server.

From SQLite to SQL Server, I'm attempting to move the data. Target and destination tables have the exact same structure....the SQL Server...CREATE TABLE [dbo].[Shop] ( [ShopID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](128) NOT NULL, [Url] [nvarchar](128) NOT NULL, PRIMARY KEY CLUSTERED ( [ShopID] ASC )) ...with SQLite:...CRE...
sqlbulkcopy sqlite
asked by Jeffrey Zhao

SqlBulkCopy import causes primary key violations in SQL Server

In C#.NET, I'm attempting to create a window-based application. I'm reading data from a csv file into a data grid view before inserting it into a database. I use...SqlBulkCopy... to database to insert data from csv file. My main worry is that I keep receiving primary key constraint errors when I attempt to put data into databases that already conta...
c# sqlbulkcopy sql-server
asked by Rushabh Shah

Importing XML data into a SQL database using sqlBulkCopy

I'm seeing issues importing an XML file utilizing...SqlBulkCopy... . This is how the XML file appears:... <root> <Automobiles> <Car Id="1" Name="SomeModel1"/> <Car Id="2" Name="SomeModel2"/> <Car Id="3" Name="SomeModel2"/> </Automobiles> </root> ...My desk appears as follows:...Int Id varchar Name ...
.net dataset sqlbulkcopy xml xmldocument
asked by ilkin

SQL Server import faster than bulk import

I have just recently been battling with myself to optimize a very heavy load. In comparison to SSIS or TSQL Bulk Insert, BULK INSERT is the quickest method, but there are things you can do to fine-tune this....Raising or reducing the rows per batch parameter may help balance the demand for CPU and memory resources (higher will reduce CPU, lower wil...
bulkinsert sqlbulkcopy sql-server
asked by Pete Carter

SqlBulkCopy.WriteToServer(DataTable) row by row: very slow

A software program that imports a...csv... database table to file. The...csv... records are similar...~500rows...~30columns... and come from unreliable sources (might contain corrupted data)....How did I do it?...CSV->DataTable->SqlBulkCopy.WriteToServer(DataTable)... . Additionally, it transfers 500 records to a remote SQL server in ...4 sec..., w...
c# sqlbulkcopy
asked by Ivan Petrov

Importing an Excel file with SqlBulkCopy fails

SqlBulkCopy works well on my local computer, however when I use the same xlsx file on the server, I receive...External table is not in the expected format....or ...No error message available, result code: E_FAIL(0x80004005)....There are almost 20.000 rows in this excel document. However, if I try with 4,000 rows, it succeeds....Below is my connecti...
asp.net c# excel sqlbulkcopy
asked by umki

C# - Importing a CSV where empty strings do not get sent through bulk import to database

There are several ways to go where you need to go....One issue I notice is that it will fail because the column will have removed itself if the individual uploads items with multiple rows and those rows have different data (let's say one column is blank on one row but filled in on a second row)....SITE32,,1,2,,... SITE32,1,2,,,... ...Columns 1, 3, ...
.net c# csv mysql sqlbulkcopy
asked by Boyd P

Problems importing into database from CSV and using SqlBulkCopy

A user may choose a.csv file and click the import button in a windows form application I have. At this stage, SqlBulkCopy should be used to import the file into a SQL Server. The issue is that I keep receiving problems, and I believe this is because fields on the import were left empty. I experience this issue:...Input string was not in a correct f...
csv sql sqlbulkcopy vb.net
asked by Brownd92

Importing a .CSV using SqlBulkCopy With ASP.Net Core

Hello, I'm attempting to move a few projects over to ASP.Net Core, but I'm having trouble figuring out the right approach to upload a.CSV file to my SQL database....Previously, I would upload the.CSV file, go through it, save the data in a DataTable, and then do a straightforward SqlBulkCopy. WriteToServer, however I've discovered that there isn't ...
asp.net-core sqlbulkcopy
asked by dev53

Import Excel file into database using Epplus and Sqlbulkcopy in MVC 5

Using the Epplus library in MVC5 and Entity Framework 6, I am importing a substantial amount of data from an Excel file into my database table. Copying the file to the database is taking a long time. I want to fast insert the data using sqlbulkcopy, but I'm not sure how to accomplish so inside my controller. The code is now functional, however the ...
asp.net-mvc-5 c# entity-framework-6 import-from-excel sqlbulkcopy
asked by Minhal

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow