Re: Converting Oracle DBF to file format usable by MS ACESS - Please help!

From: TC <donotuse_at_donotuse.com>
Date: Thu, 22 May 2003 17:03:58 GMT
Message-ID: <2q7za.72655$rt6.28125_at_sccrnsc02>


DBF files are in oracle proprietary format and cannot be read in that way.

Since you are saying these are small, you can create flat files from the tables in the oracle database and then upload the data from the flat files into MS SQL using utilities like bcp

//tc

"Joseph Mak" <jhbmak_at_yahoo.com> wrote in message news:d64bb6c6.0305200854.1a0385de_at_posting.google.com...
> Hi,
>
> I have about 4 relatively small DBF files that were generated by
> Oracle 8. I tried importing them via the import engine on MS Access,
> but these files are obviously not DBASE format and I do not have ODBC
> access to the Oracle database.
>
> I downloaded the Standard Edition of Oracle, but I'm lost as to how to
> import the DBF files. Can anyone help walk me through it?
>
> Or are there any other tools that can convert these files into a
> format that would be useable?
>
> Any help would be greatly appreciated.
>
> Many thanks,
> Joe
> jhbmak_at_yahoo.com
Received on Thu May 22 2003 - 19:03:58 CEST

Original text of this message