share data between dBASE and Access

  • Thread starter Thread starter Ronin \(theLost\)
  • Start date Start date
R

Ronin \(theLost\)

How do I share data between dBASE and Access?
How do I reach into the DBase databases directly from MS Access?
 
Look under File | Get External Data | Link Tables. Change the "Files of
Type" combo to the appropriate dBase format, then find your table(s).
 
It will work best if you establish a DSN (Data Source Name) in your
Data Source management. You'll need to use ODBC drivers for dBase.
Also, WHEN YOU ESTABLISH THE LINK TABLE, be sure to select the correct
field or fields as your primary key. Do not attempt to do this
afterwards because it will not work.

I've been linking to .dbf's (Foxpro) and it's working fine, all except
a field that has a calculation stored in it inside the foxpro table.

I haven't been very descriptive here. If you have more questions, post
them here again.

HK
 
Back
Top