[razibulislam]

Hi,
From the local pc i can send a file to a remote pc. The file type may be .xls or .mdb . But i want to send the file as well as attach/import this file to the remote pc's SQL server database. Is it possible ? Following is the code i tried to send file. But i don't understand how to import this file. In SQL Server 2000 there is an option to import table from any format database to SQL server table. I want to do it in ASP.NET environment. Thats why i posted this topics in this section.

Anyone pls suggest me what should i do ?

        string fileName = FileUpload1.FileName;
        string local = Path.Combine(@"C:\", fileName);
        string remote = Path.Combine(@"\\192.168.100.82\d$\", fileName);
        File.Copy(local, remote);

Thanks.