R
Ronin \(theLost\)
How do I share data between dBASE and Access?
How do I reach into the DBase databases directly from MS Access?
How do I reach into the DBase databases directly from MS Access?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Look under File | Get External Data | Link Tables. Change the "Files of
Type" combo to the appropriate dBase format, then find your table(s).
Type" combo to the appropriate dBase format, then find your table(s).
H
HKComputer
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
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
D
Douglas J. Steele
Access is capable of linking to dBase without the use of a DSN.