Hi,
i have some dbf file which are I dont know their content. I try to import data to access but give me error. I search lot but cannot find a solution.
Finally i try to open connection foxpro dbf file using java jdbc.odbc, connection is ok.
But the problem is i dont know internals of this dbf file, which columns they have etc... Also i dont know about dbf files. Are dbf files normal databases, i mean they contains tables, tables contains columns etc.
My question is which queries do i have to use to learn internals of this file. By this way i can import data to a text file , maybe.
Thnx.
extract data
Hot Topic
- No Connection Sting handle
- How to selectonentry an edit box in a grid.
- Change tooltips when Hovering over a grid cell.
- Sending Email through Visual Foxpro
- Auto test a vfp form of exe
- VFP7 COM+ error while calling from ASP.Net 2.0 on IIS6
- Help with code for updating table on website
- Importing to Excel
- the grid's recordsource is from combobox
- Unknown Classes Loaded in Memory
Visual FoxPro
- Report listener, HTML output on a Win98 machine.
- Foxpro Database related
- Please help
- SQL Server Express & Foxpro-populating SS from Foxpro
- Select data from a cell grid
- mscomm32 issue again
- Find command button
- Setting a date in VP 6
- Why my VFP exe file cannot be launched?
- Help with code for updating table on website
extract data
CLOlds
Hi
If you just want to see what's inside, a simple viewer is enough: http://www.totalcommander.hu/down/nezokek/dbview.zip
If it's too simple, use this one: http://www.totalcommander.hu/down/nezokek/dbfnavigator201eng.zip
Rgds,
Mark
ferlinco
You can get VFPOLEDB provider here if you don't have it:
http://www.microsoft.com/downloads/details.aspx FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en
Knvb1123
Connecting with ODBC driver doesn't mean you could query the tables. Use VFPOLEDB driver instead. What error you get from access
Using VFPOLEDB it's not hard to get data into an office app.
PS: Not all datatypes are exportable to a text file. Go with VFPOLEDB.
Rajwebdev
A DBF is a stand-alone data table that is stored directly on disk.
This sounds like you have a collection of "free" tables. Foxpro uses the standard xBase names/extensions for tables:
.DBF = The main table data file
.CDX = Associated Indexes
.FPT = Associated Memo (extended text fields)
In addtion, there may be a database container:
.DBC = VFP Database Definition Table
.DCX = Index for the Database Table
.DCT = Extended Database Information file
As for reading the contents of a table, if you can get a connection, just use "SELECT * FROM [dbf_file_name]" that will get you all of the data