Import Notes from ACT to Access

  • Thread starter Thread starter Sam Stark
  • Start date Start date
S

Sam Stark

Has anyone tried to import Notes/History from ACT package to Access? Even
if you failed, tell me what you tried. FYI notes are located in blob *.blb
file through ID's in *.hdb file. ACT sucks. The *.dbf import works like a
charm. I bet ya no one ever succeeded? It's just not worth the effort?
Warning I'm passing judgment: Any one who used ACT just didn't create any
shareable knowledge worthy of this effort. Thanks.
 
About a year ago, I was asked to convert an ACT 5.0 database into Outlook. I
did that by using Access as an intermediate device. I can't remember all the
details now, but it occurs to me that it was pretty straight-forward. There
was 1 issue which was solved by using Randy Byrne's (Outlook MVP) code from
a book he wrote.

I don't have all the details any more, but I do remember having to download
a 30 day trial of Act 6.0 to get some of the data structure. One of the
marketing folks where I work now uses ACT, so if you can ask a specific
question, I may be able to answer it for you on Tuesday.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin, I believe you're referring to the dbf file and I agree that's easy.
That contains the usual contact info like name, address, phone # etc. I'm
referring to the blob junk like notes/history which is contained in .blb and
indexed in .hdb. Have you ever exported the blob? What a great name, blob-
"binary large object." I've seen so many blobs in which the data was so
carelessly and with no forethought collected and immediately rendered
inaccessible. ACT looks like an application/database frozen in time created
20 years ago like QuickBooks.
 
I'll propose an answer. I've written a report using the ACT report writer
dumping all the blob, notes/history, to text. I then parse it to separate
records and then fields. Best I could do I think Again, anyone did it
easier?
 
Back
Top