Re: HELP - Import/Export Advice Needed

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 Received on Fri Jul 28 1995 - 00:00:00 CEST