Re: HELP - Import/Export Advice Needed

In <3ukohe$rqo_at_sunburst.ccs.yorku.ca> as360512_at_orion.yorku.ca (Manny Pires) writes:
>
>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
>
>
>

The simplest solution would be to do create a delimited flat-file. I think access will take either tab-delimited or comma-separated-values. To create such a file try something like this...

SET FEEDBACK OFF
SET HEADING OFF
SPOOL mytable.csv
SELECT '"'||fname||'","'||lname||'","'||phone||'"' FROM mytable
/
SPOOL off

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!