Importing a DBF data file

[bengalliboy]

I am trying to import a DBF file to Access in several ways but it is missing *.DBT part. Is there any way to export it some where else or Import the data to Access or even repair the FoxPro/Dbase file (file with .dbf extension)
--- TIA

 

[sunila7]

Hi,

Have u tried opening ur DBF file with Excel.... Excel can open DBF file and u can save as Excel file... and probably u can convert it to access from the Execl file

hope this helps....

Sunil

 

[bengalliboy]

Thanks, Yes I did, and Excel opens it fine. Excel only can import a record of some 65K but I got more than that... Any other way?

 

[wusinik]

In Access in the File name: box, type *.dbf

 

[Tim2]

I've imported lots of DBF files and I've never had a problem with .dbt files. In fact, I have never seen a .dbt file associated with my .dbfs. I've noticed that the import utility in Access always waits for you to ID an index file, but if you don't have one you just finish up the import without it. The only problem I've had is not having .dbf files in a DOS 8.3 name format. So, if you have a long name, make it a short one.

 

[bengalliboy]

Thanks, I thin it is a DBASE IV or Foxpro file and using ODBC Idon't see the table. Access is telling, bad table format' but I Can see the data using DBFREADER' a tool.

What way you import it in Access. I tried Link/Import data and chosed ODBC as well as DBASE local files. What am I doing wrong??

 

[Tim2]

I haven't used ODBC, just straight import. Link doesn't allow me to manipulate files the way I want, so I usually just import them. While that "duplicates" the data and is probably not too elegant, I can at least get at the data for editing.
Tim