To upload a local database tables to internet database

[micydon]

Hi I am facing a problem. I want to upload data from my local database to internet database(like exporting data) using an asp.net web page.I hve to delete all the data in internet database. That i ve done correctly. Now i want to know wether there is any method for exporting data from local database to internet database . When a asp.net button is clicked the local database's values must be loaded ito internet database . pls help me .

[Frank Kerrigan]

Export your DB table to CSV (Comma Seperated Files) Upload these via an asp/x upload page. Create SQL Server DTS that imports these into your internet db Use another/same asp/x to run the DTS via a SQL script.

---

Blog Have I http:\\www.frankkerrigan.com

[micydon]

Sir, Thanks for helping me I am new to asp.net so its very difficult for me to understand. can you pls explain this.Wht is csv, dts. pls help me its very important