Migrating data from ACT to CRM (how to get at act! data)

[westwoo...@gmail.com]

I intend on using the DMF to migrate data to CRM. The question I have
is how do I get at the underlying database that ACT uses. I see the MS
excel file for ACT has table and field mappings but I need to do some
specialized SQL. I can't seem to figure out though how to get into the
SQL database where the ACT information is stored. How do I log into
that database?

Thanks!
-Elie

[Michael Langdon]

From my days working with ACT, I thought the databse was built around
Microsoft Access. If indeed the databas is SQL then you should be able to
get your SQL DBA to grant you access to the SQL Database.

--
Rgds

Michael
MCDBA 2000 | MCITP DBA 2005

[westwoo...@gmail.com]

Michael-

Thanks for your response. As a new consultant in the CRM business I
had no idea getting data from ACT would be this hard. ACT7 uses a
proprietary instance of SQL server 2000 and it has all access admin
access disabled. You can try to purchase a password from Sage or you
can contact CRM consultants and they can probably help you out.

I'm not sure how products like scribe accomplish getting access to the
data.

On Mar 14, 2:03 am, Michael Langdon

<MichaelLang...@discussions.microsoft.com> wrote:
> From my days working with ACT, I thought the databse was built around
> Microsoft Access. If indeed the databas is SQL then you should be able to
> get your SQL DBA to grant you access to the SQL Database.
>
> --
> Rgds
>
> Michael
> MCDBA 2000 | MCITP DBA 2005
>