Home > Archive > dBASE Questions and Answers > August 2005 > HOWTO READ DBASE DATABASE









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author HOWTO READ DBASE DATABASE
MICHAEL

2005-08-23, 7:24 am

Dear All,

I am having a problem reading an old database dbase format. They used .dat
as the Extension. and in jet 4.0 or ole db / odbc in microsoft. It doesn't
allow having extension other than dbf.

Is there any way to get around with the problem ?

Thanks

Michael


Rick Gearardo

2005-08-23, 7:24 am

Rename the file?

"MICHAEL" <kocung@biz.net.id> wrote in message
news:ycv2O%238pFHA.1148@news-server...
> Dear All,
>
> I am having a problem reading an old database dbase format. They used .dat
> as the Extension. and in jet 4.0 or ole db / odbc in microsoft. It
> doesn't allow having extension other than dbf.
>
> Is there any way to get around with the problem ?
>
> Thanks
>
> Michael
>



Ken Mayer [dBVIPS]

2005-08-23, 9:23 am

MICHAEL wrote:
> Dear All,
>
> I am having a problem reading an old database dbase format. They used .dat
> as the Extension. and in jet 4.0 or ole db / odbc in microsoft. It doesn't
> allow having extension other than dbf.
>
> Is there any way to get around with the problem ?


..dat is not a standard dBASE table format. I can't even recall what
created/used it.

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
Les Shewchuk

2005-08-23, 11:24 am

If renaming the file doesn't work, try opening the table with dBase 5 DOS or
dBase 5.5 or 5.7 for windows. If they really are dBase tables, it should
work. Just remember to use the extension, or dbase will assume .dbf and not
find the file.

use MyTable.dat

Les Shewchuk

"MICHAEL" <kocung@biz.net.id> wrote in message
news:ycv2O%238pFHA.1148@news-server...
> Dear All,
>
> I am having a problem reading an old database dbase format. They used .dat
> as the Extension. and in jet 4.0 or ole db / odbc in microsoft. It

doesn't
> allow having extension other than dbf.
>
> Is there any way to get around with the problem ?
>
> Thanks
>
> Michael
>
>



Robert Bravery

2005-08-23, 8:24 pm

HI,

What makes you think it is a dbase file. If it is rename the file

Robert

"MICHAEL" <kocung@biz.net.id> wrote in message
news:ycv2O%238pFHA.1148@news-server...
> Dear All,
>
> I am having a problem reading an old database dbase format. They used .dat
> as the Extension. and in jet 4.0 or ole db / odbc in microsoft. It

doesn't
> allow having extension other than dbf.
>
> Is there any way to get around with the problem ?
>
> Thanks
>
> Michael
>
>



MICHAEL

2005-08-24, 3:24 am

Hi,

THanks to All, for quick respond

It is true, by renaming I can read the database.
The problem is, I have to make it compatible with older program which it is
using .dat as their extension.

I am planning to make a viewer of the database. w/o renaming the file.
Because it might be used when viewing the database.

Copying before renaming may work, but the information is not up to date.
This would be my last effor if there is no way around.

Thanks All

Regards
Michael

"Robert Bravery" <me@u.com> wrote in message
news:mIjMyWBqFHA.1040@news-server...
> HI,
>
> What makes you think it is a dbase file. If it is rename the file
>
> Robert
>
> "MICHAEL" <kocung@biz.net.id> wrote in message
> news:ycv2O%238pFHA.1148@news-server...
> doesn't
>
>



David Bridger

2005-08-24, 3:24 am

MICHAEL wrote:
> Hi,
>
> THanks to All, for quick respond
>
> It is true, by renaming I can read the database.
> The problem is, I have to make it compatible with older program which it is
> using .dat as their extension.
>

Didn't WordPerfect make .dat files as secondary merge files?

David Bridger
Marilyn Price

2005-08-24, 7:24 am

In article <4QvsvfFqFHA.1876@news-server>, wincrafters@sasktel.net
says...
> MICHAEL wrote:
> Didn't WordPerfect make .dat files as secondary merge files?
>
> David Bridger
>


There was also a very old accounting program (I forget the name) written
for either dBase III+ or FoxBase that purposely used a .dat extension to
confuse the issue. The source code had no problems reading the data,
but other programs (that understood .dbf files) would take one look at
the extension and say that they didn't know what to do with it.
Primitive form of security.

--
Marilyn Price
M. P. Data
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com