469,332 Members | 6,678 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,332 developers. It's quick & easy.

ACT to Access

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
Nov 13 '05 #1
4 5615
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


Nov 13 '05 #2
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.
Nov 13 '05 #3
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.


Nov 13 '05 #4
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.
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

63 posts views Thread by Jerome | last post: by
13 posts views Thread by Simon Bailey | last post: by
reply views Thread by Frederick Noronha \(FN\) | last post: by
64 posts views Thread by John | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
37 posts views Thread by jasmith | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.