Can't insert data! need you help

[Tapanon]

Hey guy,
i try to insert data from Excell file to SQL 2005, then i created window application to insert data on local is success but i can't insert on SQL 2005 .
I got TimeOut Expired. Any one help me plaese..

[wisemx]

Hi,
Yes we can help with this.
Can you list the exact steps you are taking?
i.e. Local SQL Server using Import task wizard to remote DASP SQL Server 2008, etc.
All the best,
Mark

[Tapanon]

Do you mean step in my source code right?

1. Read file (Stream) file store in local
2. Open Connection
3. Insert all

[wisemx]

...I thought you were just trying to use the task wizard to import Excel records.
If you're trying to stream it via code I don't have anything for ya. sorry ;-)
Hopefully someone else will chime in. . .
All the best,
Mark