Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE EXPORT TO EXCEL, DBASE???
Hello, Ralph.
If you need to import data, it can be done easily.
1. setup the ODBC datasource from 'control panel'
2. once this datasource is working, open Access or Excel to import data
3 if you want to import data from Access, go to File/get External data in
pull down menu. you can do either import or link to the table you want.
4 if you wan to import data from Excel, go to Data/get External data/New
database query, then follow the step.
hope this helps...
"RALPHNOBLE" <ralphnoble_at_aol.com> wrote in message
news:20021126214616.19783.00000186_at_mb-ba.aol.com...
> Thanks ... the Oracle database is of property records ... there's seven
tables
> in the database ... we simply need the data exported into a format we can
> import into Microsoft Access, FoxPro or Excel. We're talking about 12K
records
> per table. I know in SQL Server it's a simple DTS export to the ODBC
> application of my choosing. Is it that more difficult in Oracle just to
get the
> data in the tables exported to fixed-width or delimited flat text files,
or
> Excel, dBase or Access or something????
>
> Thanks,
>
> Ralph
>
Received on Wed Nov 27 2002 - 13:44:23 CST