12-09-2009 10:08 AM
I need help to get data from database contacts table. I want to read data of some columns (fields) of contacts table from Act database and export to other Sql server database. can any one advice how to go it by T-SQL?
thanks in advance,
12-10-2009 07:35 AM
You'll need to ask Sage for the SA password for your dB to do that via SQL -> SQL.
You could use the OLEDB to access the Contact Field Data and simply output to Excel and then save as csv?
Caldere Associates Ltd.
12-10-2009 09:47 AM
If your ACT software is 11.1 or higher, you have the ACTREADER password utility for free. You dont need the SA password to do what you want. Use it to set the password for the ACT SQL instance, then using Management Studio on the SQL instance that you have full rights on, play with the following script. There should be enough here to get you going. Note; You'll need to edit this for your own ACT7 SQL instance name:
EXEC sp_addlinkedserver @server='ACER-01\ACT7'
EXEC sp_addlinkedsrvlogin 'ACER-01\ACT7', 'false', NULL, 'actreader', 'PW$ecret1'
IF OBJECT_ID('[MyLocalDB].dbo.[TBL_LINKEDCONTACTS]', 'U') IS NOT NULL
DROP TABLE [MyLocalDB].dbo.[TBL_LINKEDCONTACTS]
SELECT * INTO [MyLocalDB].dbo.[TBL_LINKEDCONTACTS] from [ACER-01\ACT7].[ACT2010Demo].dbo.[TBL_CONTACT]
EXEC sp_dropserver 'ACER-01\ACT7', 'droplogins'
12-11-2009 08:43 AM
Actually, you can get the ACTReader that will work with ANY Premium edition of ACT!