Read Act! data into Access??

[Kc-Mass]

Does anyone have experience reading Act! (contact management software) data
into Access.
Someone suggested to me that the data is in Foxpro tables, which would
seemingly be easy but I don't know that that is true.

Any help on experiences doing this, file layouts etc would be much
appreciated.

I believe the Act! installed is from about 2002 so is probably version 6?

Thx
Kevin C

[Albert D. Kallal]

Actually, Act used to be dbase format, and FoxPro of the day was considered
a superiors "clone" of the original product.

You can likely open the act tables, but does not act has a export ability?

Since the act database is MANY related tables, then exporting one table
likely will not give you want you need. You would thus then need to know all
of the tables, and structures to do a proper import. Learning the tables,
and the complex act layout could take some time.

So, in place of directly importing the actual data tables from act, it you
would be MUCH MUCH better off to use a *export* feature of act, and produce
a excel, or comma delimited file that then can be imported...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com

[David W. Fenton]

"Albert D. Kallal" <Pl************ *******@msn.com wrote in
news:UG8Xg.1228 87$5R2.119408@p d7urf3no:

Actually, Act used to be dbase format, and FoxPro of the day was
considered a superiors "clone" of the original product.

But you don't get write access. There used to be an ODBC driver or a
VBA automation interface (I can't remember which). That's the
preferred method for accessing and manipulating the data.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Kc-Mass]

Thanks to both of you for the info/suggestions.
What I need to do is write a procedure to create the Access tables and
populate them with Act! data (monthly update).
My mission is to be able to read and report with but not alter Act! data.

Again Thanks

"David W. Fenton" <XX*******@dfen ton.com.invalid wrote in message
news:Xn******** *************** ***********@127 .0.0.1...

"Albert D. Kallal" <Pl************ *******@msn.com wrote in
news:UG8Xg.1228 87$5R2.119408@p d7urf3no:

>Actually, Act used to be dbase format, and FoxPro of the day was
considered a superiors "clone" of the original product.

But you don't get write access. There used to be an ODBC driver or a
VBA automation interface (I can't remember which). That's the
preferred method for accessing and manipulating the data.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[David W. Fenton]

"Kc-Mass" <co********@com cast.netwrote in
news:cY******** *************** *******@comcast .com:

What I need to do is write a procedure to create the Access tables
and populate them with Act! data (monthly update).
My mission is to be able to read and report with but not alter
Act! data.

The problem I found was that all the data in the ACT! DBF files was
not readable -- it was sometimes stored in a byte-type of field with
data that wasn't easily retrievable. If you can see the data you
want by looking at the DBF files directly, then that will work, but
if you need data that's in one of the packed formats, you'll need to
use a data interface provided by ACT!.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/