Hi all,

I'm trying to import an excel file to MS SQL Express 2005 by using VS 2003 VB.Net in ASP.Net.

The problem I'm facing now is when I import the data by using IMEX=1, its running OK in my laptop the one i used to develop this program.

However, when I run the application in Windows Server 2003 R2, it didn't run as smooth as my laptop.

The excel file has total 2156 rows. It can be imported all in my laptop but in Server OS, it only import 248 rows.
If I remove this IMEX = 1 from my OLEDB Connection, it (server) will import all rows that is 2156.

The reason I put this IMEX = 1 is among the columns, there is one column which values are NULL mix with Number. If I use without IMEX, it will import all rows as NULL for this column. So, I searched the net and found that this IMEX = 1 will treat as Text so I used it in my program.
Strange is it works on my PC but not in server.

Anybody any suggestions???
Thanks.
scsfdev