0 Replies - 538 Views - Last Post: 09 February 2010 - 02:55 AM Rate Topic: -----

#1 razibulislam  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 01-February 10

How to Copy the file to the SQL server database from Local PC to Remot

Posted 09 February 2010 - 02:55 AM

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.

Is This A Good Question/Topic? 0
  • +

Page 1 of 1