Exporting databse table data in SQL Server 6.5 into text files

[himaushu]

Hi,

I have to export the table data from my databse into text files as I nedd to put it in Informix database using a sheel script. Is there a way by which I can do this.

Is there any other way by which I can put the data from SQL Server to Informix.

Any takers,

Thanking you in advance.

Bye for now,

Himauhu

[Gregory]

1) use script that allows to export all user-defined tables into text files
(see http://www.swynk.com/downloads/sp_bcpout_alltables.sql)
2) use MS Access, for example, link SQL Server tables to Access database,
link Informix tables to same Access database, then do insert

------------
himaushu at 3/11/99 5:04:36 AM

Hi,

I have to export the table data from my databse into text files as I nedd to put it in Informix database using a sheel script. Is there a way by which I can do this.

Is there any other way by which I can put the data from SQL Server to Informix.

Any takers,

Thanking you in advance.

Bye for now,

Himauhu