Hi, How will you transfer data from Oracle to SQL Server 6.5. Can I first create an export file from oracle and then run bcp to get the data to SQL Server 6.5. It is saild that that an export file is recognised only by Oracle Is it true. Does it make any difference if I run SQL 7 on Win NT or 95

-- Anonymous, June 26, 1999

Answers

John,

With ORACLE SQLPlus write SQL Statement, use SPOOL Command to write your table data to the file (I spooled the data into the .txt file). Then bcp it into SQL Server.

Hope it helps.

Kothans.

-- Anonymous, June 27, 1999