25 files x 1 Million rows = 25 Million If you say each row is 1024 bytes. Its totally 25 GB of memory required. As you might already know, when RAM is not sufficent the system writes to harddisk & its slow. Unless you have free space of 40GB (to accomodate calculation issues), you cannot run your application & still it will be slow. So your approach is to break it up into pieces. You got few approaches: 1. Dont use datatables and use memory streams, use SqlCommand - this is more code, i guess 2. If you want to use datatables. You have to run the BulkCopy, for each datatable & call DataTable.Dispose() method (and may be call to Garbage collector, as Dispose will not free memory immediatly) after each use. 3. Use SQL Server, to import the files directly. DTS / SISS supports importing of various file formats, excel, csv, access. It will need a SQL command, which will take the file location & it will import it. You can google up for the sql syntax or use DTS Export / Import wizard & in last step, save the command.

Abi ( Abishek Bellamkonda ) My Blog: http://abibaby.blogspot.com =(:*

Use valid email addresses. I don't think me@me.com is valid. Usually the problem is with from/to email or MailServer. Try other values it should work. Abi ( Abishek Bellamkonda ) My Blog: http://abibaby.blogspot.com =(:*

Set HtmlInputFile.Accept property to a comma-separated list of MIME encodings available at http://www.w3schools.com/media/media_mimeref.asp Abi ( Abishek Bellamkonda ) My Blog: http://abibaby.blogspot.com =(:*

InvalidCastException? I can't really see the line numbers in the code, so it is little difficult to point out exact solution. Looks like you are passing incorrect data type (Turn on Option Strict, Explcit). Also usually before sending email, we need to set the SmtpMail.MailServer property. It does not look like you did. Make sure it points to correct mail server ID. For example SmtpMail.MailServer = "mail.companywebsite.com" Make sure you get proper mail server address. ' Call this function, this function can be further improved for performance, bla bla ' But this does our work for now. ' You have to check this on server (you can do the same thing on client but it will be broken) ' Also make sure you set the IIS Execute permissions for the folder is set to "None" Function IsValidFileType(MyPostedFile as HttpPostedFile) As Boolean Dim acceptableFileTypes as string() = New String(){ ".xls", ".pdf", ".jpeg", ".jpg" } for i=0 to acceptableFileTypes.Length - 1 If MyPostedFile.FileName.EndsWith(acceptableFileTypes(i)) Then Return True Next Return False End Function Abi ( Abishek Bellamkonda ) My Blog: http://abibaby.blogspot.com =(:*

You have DataListCommandEventArgs, instead of DataGridCommandEventArgs (you got confused betwwen DataList and DataGrid). The error message is correct, just look at it...

Neel07 wrote:

"dgModule_ItemCommand(object, System.Web.UI.WebControls.DataListCommandEventArgs)' does not match delegate 'void System.Web.UI.WebControls.DataGridCommandEventHandler(object, System.Web.UI.WebControls.DataGridCommandEventArgs)'"

Abi ( Abishek Bellamkonda ) My Blog: http://abibaby.blogspot.com =(:*