Export ACT 4.0 to File
Posted on 2011-03-07
I know nothing about ACT but have been tasked with trying to take the data from an ACT 4.0 installation and importing it into an existing (but empty) MSSQL 2005 database.
I have seen a few references that say ACT can be exported to a text file which could be imported into MS Excel. That file could then be imported into the database. Problem is nothing indicated to which version(s) this applies to.
The data actually exists at an office out of the country so I only have access "through" another person who is there and will have to do whatever needs done in ACT and send it to me to configure and then send back.
I am find with the SQL and Excel part but need to know what to tell the person there as to what to do to get files for me.