views:

35

answers:

2

Any ideas ?

I think the original source was a goldmine database, looking around it appears that the file was likely built using an application called ACT which I gather is a huge product I don't really want to be deploying for a one off file total size less than 5 meg.

So ...

Anyone know of a simple tool that I can run this file through to convert it to a standard CSV or something?

It does appear to be (when looking at it in notepad and excel) in some sort of csv type format but it's like the data is encrypted somehow.

+1  A: 

I am unaware of any third party tooling for opening these files specifically, although there is an SDK available for C# which could resolve your problem with a little elbow grease.

The SDK can be aquired for free Here

Also there is a developer forum which could provide some valuable resources including training material with sample code Here

On top of that there are numerous resources available Here

Also, out of interest since ACT is a Sage product have you any Sage software floating about which you could attempt to access the data with? Most offices have!

Failing all of the above there is a trial available for ACT! Here!

Good luck with your problem!

Yoda
The force is strong with this one ... however i don't believe sage is the answer on the basis that I have been informed that the file actually came from goldmine, having said that ... I looked in to our sage software and apparently Sage and act are completely separate prodcuts.
Wardy
+1  A: 

Ok this is weird,

I got a little confused because the data looked a complete mess, in actual fact the mess was the data, that's what it was meant to look like.

Simply put, i opened the file in notepad, seemed to have a sort of pattern so i droppped it on excel.

Apparently excel has no issues reading these files ... strange huh !!!

Wardy