Re: Easiest way to transfer data from Oracle to SQL Server using a file.

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Jun 2003 06:44:45 -0700
Message-ID: <2687bb95.0306170544.16cc5225@posting.google.com>

"Linus Nikander" <linus_at_nikander.net> wrote in message news:<Y6BHa.38775$X2.822_at_news2.bredband.com>...
> Hi, what is the easiest way to transfer a table (including its data) from an
> Oracle installation (8.1.7) to an SQL Server 2000 one using a file ? I've
> been looking at using oracle's 'exp' utility to export data, but i can't
> seem to find any way for SQL Server to import it. Another way would be to
> export into a CSV file and then import that. All pointers appreciated.
>
> And yes, using a file is a must, I know that all this could be accomplished
> muche more easily using a db-> db connection but that simply isn't an
> option.
>
> //Linus Nikander - linus_at_nikander.net

For instructions on how to generate delimited files see How do I export a database table to a flat file ? at url => http://www.jlcomp.demon.co.uk/faq/flatfile.html

HTH -- Mark D Powell -- Received on Tue Jun 17 2003 - 08:44:45 CDT