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);