Automate Import/Export to text or CSV file  
Author Message
Randeep





PostPosted: Thu Feb 12 16:11:08 CST 2004 Top

SQL Server Developer >> Automate Import/Export to text or CSV file

I need to export one of my SQL Server 2000 tables to a text file. At which
point, someone takes this file and inputs some data and gives it back to me.
I then must import this and its updated data back to my original table.

Right now I'm writing a VB program that does this, but I have the feeling
there's an eaiser way built into SQL Server 2K.

I also need the import and export of this text (or csv) file automated to
run at specified intervals.

Any suggesstions?

Thanks.

SQL Server193  
 
 
anonymous





PostPosted: Thu Feb 12 16:11:08 CST 2004 Top

SQL Server Developer >> Automate Import/Export to text or CSV file 2 DTS Packages. One to export, one to import. Schedule the jobs to run whenever you want. The packages can put the .xls somewhere on your network, then go import it from the network. Just a thought.