DBF and DBT extensions

I exported a table from MS Access into a DBF. It has 2 fields, one of which
is a memo field. I'm going to have to import the DBF into a FoxPro database
on Monday. When I exported, MS Access created two files, a DBF and a DBT
file. What is the DBT for? Am I going to have issues when I try to import
into FoxPro?

I did a search and it appears the DBT is contains the memo field which could
make some sense. The DBF is 5K and the DBT is 205K. Does the import process
automatically look for the DBT file in the same folder?

thanks!

Fred
Sun Mar 07 13:18:48 CST 2004

I don't think you exported this to an FoxPro database, but a dBase one. Fox
would be a .DBF for the regular fields and and an .FPT for the memo fields.
Since you got a .DBT, I think it's dBase, but FoxPro should still be able to
open it, and I think it will ask you to convert it to FoxPro format when it
does.

Fred
Microsoft Visual FoxPro MVP


"shank" <shank@tampabay.rr.com> wrote in message
news:M0J2c.220109$jH.2211174@twister.tampabay.rr.com...
> I exported a table from MS Access into a DBF. It has 2 fields, one of
which
> is a memo field. I'm going to have to import the DBF into a FoxPro
database
> on Monday. When I exported, MS Access created two files, a DBF and a DBT
> file. What is the DBT for? Am I going to have issues when I try to import
> into FoxPro?
>
> I did a search and it appears the DBT is contains the memo field which
could
> make some sense. The DBF is 5K and the DBT is 205K. Does the import
process
> automatically look for the DBT file in the same folder?
>
> thanks!
>
>

Anders
Sun Mar 07 13:24:47 CST 2004

"Shank"
Have you used the 'save as dBase' option in Access?
DBT is a dBase memo file attachment. The corresponding VFP extension is
*.FPT. FoxPro can read dBase memos.
If an Access variable length field has no text limit it will be converted to
a memo field in VFP (or dBase) files. If that field actually never ever
contains more than 255 characters you can set a limit in Access and it will
be saved as a character field instead of a memo.
VFP can easily open and read Access database tables with Access ODBC which
is as a rule installed wherever Access is installed.
h=SQLCONNECT() && open or create a DSN link to the MDB
SQLTABLES(h) && the table names in the MNDB.
BROWSE
SQLEXEC(h, "SELECT * FROM tablename, 'cursor1')
BROWSE
-Anders

"shank" <shank@tampabay.rr.com> wrote in message
news:M0J2c.220109$jH.2211174@twister.tampabay.rr.com...
> I exported a table from MS Access into a DBF. It has 2 fields, one of
which
> is a memo field. I'm going to have to import the DBF into a FoxPro
database
> on Monday. When I exported, MS Access created two files, a DBF and a DBT
> file. What is the DBT for? Am I going to have issues when I try to import
> into FoxPro?
>
> I did a search and it appears the DBT is contains the memo field which
could
> make some sense. The DBF is 5K and the DBT is 205K. Does the import
process
> automatically look for the DBT file in the same folder?
>
> thanks!
>
>

Eric
Sun Mar 07 13:25:58 CST 2004

Hello, shank!
You wrote on Sun, 07 Mar 2004 17:32:28 GMT:

s> I did a search and it appears the DBT is contains the memo field which
s> could make some sense. The DBF is 5K and the DBT is 205K. Does the
s> import process automatically look for the DBT file in the same folder?

Yes. A DBT file is indeed a memo file. I believe the DBT extension was used
in dBase. FoxPro and Visual FoxPro use the .FPT file extension. There
shouldn't be a problem accessing the DBF+DBT in Fox.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Davide
Sun Mar 07 17:04:42 CST 2004

shank,

> I did a search and it appears the DBT is contains the memo field

Yes, DB3 databases stores the memo field's data in a DBT file.

Regards,
Davide
---------------------------------------------------
Printfil - Windows Printing System for Applications
http://www.guolo.com/printfil
---------------------------------------------------