Re: HELP - Import/Export Advice Needed
Date: 1995/07/27
Message-ID: <odysscci.411.0015BD38_at_teleport.com>#1/1
In article <3v9agkINNh9l_at_intevep.intevep.pdv.com> mario.ochoa_at_caracas.bbs.ve (Luis M Ochoa) writes:
>Path: nntp.teleport.com!psgrain!usenet.eel.ufl.edu!newsfeed.internetmci.com!europa.chnt.gtegsc.com!cantaloupe.srv.cs.cmu.edu!das-news2.harvard.edu!oitnews.harvard.edu!news.sesqui.net!intevep!intevep!usenet
>From: mario.ochoa_at_caracas.bbs.ve (Luis M Ochoa)
>Newsgroups: comp.databases.oracle
>Subject: Re: HELP - Import/Export Advice Needed
>Date: 28 Jul 1995 00:20:36 GMT
>Organization: FWCC
>Lines: 34
>Message-ID: <3v9agkINNh9l_at_intevep.intevep.pdv.com>
>References: <3ukohe$rqo_at_sunburst.ccs.yorku.ca>
>NNTP-Posting-Host: 162.122.22.95
>X-Newsreader: WinVN 0.99.5
>MIME-Version: 1.0
>Content-Type: Text/Plain; charset=ISO-8859-1
>In article <3ukohe$rqo_at_sunburst.ccs.yorku.ca>, as360512_at_orion.yorku.ca
>says...
>>
>>Hi,
>>
>> Can anyone tell me how I can export tables from Oracle 6 so that
>>they can be incorporated into MS Access. Or for that matter, how I
>>can import data from Oracle into Access. Is this even possible? Any
>>help would be greatly appreciated. Thanks in advance,
>>
>>Manny
>>
>Hi,
>As far as I know, there isn't a direct way to do that, but I've managed
>through a two-step process: export the table as an ASCII file, and then
>import the ASCII file to Access. I don't know exactly what kind of formats
>does Access support, but the comma separated values is almost universal to
>all programs, so:
>SQL> spool table.txt
>SQL> select '"'||field1||'","'||field2||'","'||...||fieldn||'"'
> 2 from tablename
>SQL> spool off
>You gotta make sure to set the linesize long enough to hold an entire
>record, and you have to make a to_char(field) to all non-char columns.
>Good luck,
>Luis M Ochoa
>Cardon, Venezuela
You can start Access and pull down the file menu and choose import. Then choose an sql source (an Oracle 6 data source that you set up with the odbc manager.). It should import longs (as memo fields).
Jim Kennedy Received on Thu Jul 27 1995 - 00:00:00 CEST