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

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Thu, 22 May 2003 14:34:35 -0500
Message-ID: <0h9qcvk4b8q39bhhaeijco87lecfp59qi5_at_4ax.com>


It seems from his posting the Joe does not have access to the Oracle database, so he is out of options..

"TC" <donotuse_at_donotuse.com> wrote:

>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
>
>

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu May 22 2003 - 21:34:35 CEST

Original text of this message