Tuba

When you prepare your data to export to Excel and use the following line in your code

Response.ContentType = "application/vnd.ms-excel"

You might need to add the following line as well

Response.ContentEncoding = System.Text.Encoding.UTF7

so that you can prevent having character related problems

I happened to get this error because the file "ProjectName.vbproj.webinfo" file was missing in my project folder.

I have my project under source control . The source control does not have the webinfo file for you to get into your project. This is because this file keeps track of a project's virtual root location and it can be different for different people working on the same project.  So when you have this file in your project folder you don't need to add the project to your solution by using “Add Existing Project From Web”, you can use “Add Existing Project” with Visual Studio.

Here is the content of the file:

Using "Bulk Insert" in SQL 2000 with files containing data with Unicode characters often cause problems.

I tried to import data from a Unicode file to a nvarchar field using a format file with SQLNCHAR type. It ended up with no data transfer.

Here are the lines from my tries:

From .fmt file : 4  SQLNCHAR  0  255 "\r\n" 4  Text LATIN1_General_CI_AS

From Create table script: [Text] nvarchar (255)

TransactSQL: BULK INSERT    Tuba TEMP   FROM
   '\\1994\IRIS\Queue\file10_10.txt'   WITH    (FORMATFILE = '\\1994\IRIS\Format\bcp.fmt' ,  FIRSTROW = 1 ,  ROWTERMINATOR = '' )

Simply changing the column type to ntext and using SQLCHAR in the format file, the data was finally transfered happily to my SQL Table.