Brain Dump Needed on Connecting to Programs

[sgfromny]

I have a access database that has evolved into an entire production tracking application. The Next phase of this application is to get front end data. I need help on how I can get info from other programs, Specifically ACT!2000, into my access database. I dont have a clue on the code required to grab info from act! or any application for that matter.

Any Help or guidance is appreciated.

Thanks

 

[mpastore]

ACT files are actually (for the most part) .DBF file format. You can read them using Foxpro. You may also be able to link them to MS Acess using the Dbase or FoxPro ISAM.

 

[sgfromny]

I was looking to get the info via VBA

 

[mpastore]

Sub open_act()
' this example uses DAO, need reference to that in order to run
' assumes a dbase table called v:\dev_mike\person.dbf
Dim db As Database
Set db = DBEngine.Workspaces(0).OpenDatabase("v:\dev_mike", False, True, "DBASE IV;&quot

Dim rs As Recordset
Set rs = db.OpenRecordset("person&quot
Set db = Nothing


End Sub