Importing MS Access into ACT!

[Jim Lee [Symantec]]

On 24 Sep 1998 13:44:57 GMT, elaine alligood wrote:

>Configuration Information:
> Operating system: Windows NT 3.51
> Network: --Other--
>
>I have read the tech documents re: importing comma delimited files
>into ACT. Thus, it appears that one can import from Access 97 into
>ACT. But, before I convince our group to buy it and try it, I want
>to confirm that it is possible to do this conversion.
>
>We have a 3-4000 name and address file in MS Access 97 and will want
>to convert it to ACT.
>
>What problems can we expect? What to watch out for?
>
Hi Elaine,

You have posted in WINNT ACT! 4.0 general, and specified that you are
running NT 3.51. Is this correct? The reason I ask is that ACT! 4.0 is
not certified to run on NT 3.51.

ACT! 4.0 can import in dBase or Text-Delimited formats. In your case I
would recommend the use of dBase as the format of choice. I would make
the first records the names of all the fields, this will facilitate
the mapping process. Make sure you have closed all applications but
ACT! when importing to give ACT! the maximum resources to convert.
Your free disk space should be at least 3Xs the size of your largest
database (all 17 data files added together). If this is the database
the size will be approximately 8mbs so you would want at least 24mbs
available.

When mapping do not map to first name last name and contact. If you
have first and last name leave the contact unmapped, ACT! will combine
the first and last in the contact field. Do not map to the Note field
unless you have a dBase memo field and use dBase.

I will generally break up large imports into smaller chunks to
facilitate the import.

Let us know if we can be of further help.

Jim Lee [Symantec Corp.]

Please continue to post your messages to the public discussion groups
as Symantec does not provide support via private e-mail.

If you have difficulty getting a response, please read the following
article:

http://service1.symantec.com/SUPPORT/sharedtech.nsf/docid/1998527114414

For free technical support newsletters, Knowledge Base support
articles, our Online Support Genie, and FAQs, visit our ACT! support
page:

http://www.symantec.com/act/