TransferDatabase

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

Hi all,

Can anyone give me some examples (or point me to a good source of
information) on how to import a dbase/foxpro table into an access database?
At this point I have a completely blank access database.

Regards
Dale
 
First, create Access tables with the structure (field names and data types)
to match the files you want to import. Then link to your dbase/foxrpo files.
It will recognize Dbase III, Dbase IV, and Dbase 5 file structures. Create
append queries in Access to copy the data from the linked tables to the
Access tables. Then delete the links to the dbase files.
 
Thanx for the reply. Problem tho.

I will not know the data structure ahead of time. I'd like to do this
programatically via automation. Problem is, I know just enough to be
dangerous. I'm hoping that knowledge is half the battle.

Sorry I wan't more up front to begin with.

Dale
 
Interesting you will not know the structure. This is not a big issue. Link
the dbase files. Then you can select the file, Right Click, select copy,
deselect the file, right click, select paste. You will get a dialog of
choices. You could just copy structure and data, or if you will be importing
more than once, copy only the structure, and do the import as I previously
suggested.
 
I see from a later post that you want to do this under program control
for tables of arbitrary structure. Depending on what version of dBase/FP
you are faced with, you may be able to use the Jet xBase ISAM by writing
code that builds and executes SQL make-table queries using this syntax
to access the dBase files:

SELECT * INTO NewTable FROM DBTABLE IN "C:\DBASE\IMPORT" "dBASE IV;"

In that example, the dBase table is DBTABLE.DBF and "C:\DBASE\IMPORT" is
the name of the folder it's in (along with any associated index and memo
files). All these must be old-style short names (or the short
equivalents of modern long names).

With recent versions of xBase I'm not quite sure what the procedure
would be, but I presume one needs to use an ODBC driver and write code
to build appropriate connection strings.
 
Back
Top