By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,160 Members | 1,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,160 IT Pros & Developers. It's quick & easy.

Read Act! data into Access??

P: n/a
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
Oct 11 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Oct 11 '06 #2

P: n/a
"Albert D. Kallal" <Pl*******************@msn.comwrote in
news:UG8Xg.122887$5R2.119408@pd7urf3no:
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/
Oct 11 '06 #3

P: n/a
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*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Albert D. Kallal" <Pl*******************@msn.comwrote in
news:UG8Xg.122887$5R2.119408@pd7urf3no:
>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/

Oct 11 '06 #4

P: n/a
"Kc-Mass" <co********@comcast.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/
Oct 12 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.