ACT to Access

[Doug]

I have exported an ACT file as a dbf. It created ~26 files with various
extensions (abc, abu, adb, adx, sdb, blb, ddb, ddf, etc.) My goal for
exporting was to extract the Notes. It appears the notes are located in
the file with the .blb extension (I can see the text in Notepad, along with
a bunch of other characters). When I import the dbf file into Access, it
only imports the main contact list. How do I import the Notes too?

Thanks

[Tom van Stiphout]

On Tue, 08 Mar 2005 18:20:42 GMT, Doug <dm*************@satx.rr.com>
wrote:

By downloading the ACT! SDK. Study it, and you'll realize the blb file
needs to be accessed using the Act object model.

-Tom.

I have exported an ACT file as a dbf. It created ~26 files with various
extensions (abc, abu, adb, adx, sdb, blb, ddb, ddf, etc.) My goal for
exporting was to extract the Notes. It appears the notes are located in
the file with the .blb extension (I can see the text in Notepad, along with
a bunch of other characters). When I import the dbf file into Access, it
only imports the main contact list. How do I import the Notes too?

Thanks

[Doug]

Tom van Stiphout <no*************@cox.net> wrote in
news:5n********************************@4ax.com:

On Tue, 08 Mar 2005 18:20:42 GMT, Doug <dm*************@satx.rr.com>
wrote:

By downloading the ACT! SDK. Study it, and you'll realize the blb file
needs to be accessed using the Act object model.

-Tom.

Thanks. I found some of your other posts (after posting my original
message) and don't have the know how (right now) to write the necessary
program to access the data. So, I found a company or two that will take
the ACT file and convert it to Access for me. One of those is:
http://cicorp.com/act/convert/

Are you familiar with anyone who can provide that type of service? I have
about 480 contacts with ~6,000 - 8,000 note entries. $180 to pay someone
else is cheaper than the time it would take for me to learn it.

[Tom van Stiphout]

On Wed, 09 Mar 2005 04:19:17 GMT, Doug <dm*************@satx.rr.com>
wrote:

My quote would be several times higher. Go with the $180 resource.
-Tom.

Tom van Stiphout <no*************@cox.net> wrote in
news:5n********************************@4ax.com :

On Tue, 08 Mar 2005 18:20:42 GMT, Doug <dm*************@satx.rr.com>
wrote:

By downloading the ACT! SDK. Study it, and you'll realize the blb file
needs to be accessed using the Act object model.

-Tom.

Thanks. I found some of your other posts (after posting my original
message) and don't have the know how (right now) to write the necessary
program to access the data. So, I found a company or two that will take
the ACT file and convert it to Access for me. One of those is:
http://cicorp.com/act/convert/

Are you familiar with anyone who can provide that type of service? I have
about 480 contacts with ~6,000 - 8,000 note entries. $180 to pay someone
else is cheaper than the time it would take for me to learn it.

[Doug]

Doug <dm*************@satx.rr.com> wrote in
news:Xn**********************************@207.115. 63.158:

Thanks. I found some of your other posts (after posting my original
message) and don't have the know how (right now) to write the
necessary program to access the data. So, I found a company or two
that will take the ACT file and convert it to Access for me. One of
those is: http://cicorp.com/act/convert/

Are you familiar with anyone who can provide that type of service? I
have about 480 contacts with ~6,000 - 8,000 note entries. $180 to pay
someone else is cheaper than the time it would take for me to learn
it.

For anyone else who may be in the same predicament, I ended up purchasing a
software product called InfoACT (http://www.infosurfer.net/infoact.htm).
It is the best $199 of my companies money I've spent in a while. It
converted all the tables and kept the relationships. From there I was
easily able to modify the notes tables as needed to fit into my DB.