Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tchinedu
Yak Posting Veteran
71 Posts |
 Posted - 2005-07-25 : 22:14:55
|
| Please help guys,I'm currently working on a project to import data from ACT! datafiles into my SQL2000 server using ADO.NETI'm currently able to access the contacts, email, history, notes files using the Microsoft Jet OleDb driver.turns out, some of the fields in the ACT! data files are compressed... Is there a way to decompress these fields.PS: I have to do everything in my code, I can't use any gui tools etc. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-25 : 22:25:37
|
| Depends on the compression they're using. They would be compressed for a reason, so don't bank on being able to crack them. Do you have the ACT! API's to get to the data? |
 |
|
|
tchinedu
Yak Posting Veteran
71 Posts |
Posted - 2005-07-26 : 10:26:01
|
| I have the API, Can I use the API to read from flat data files likethe contacts.dbf etc. All I'm getting are a bunch of files...do I have to install the act application to be able to access the data in these .dbf files....I'm hoping not |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-07-26 : 11:26:01
|
| DBF files are generally FoxPro or Dbase database files. Try opening them with one of those drivers.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
tchinedu
Yak Posting Veteran
71 Posts |
Posted - 2005-07-26 : 13:33:12
|
[quote]Originally posted by MichaelP
DBF files are generally FoxPro or Dbase database files. Try opening them with one of those drivers.MichaelThanks Michael.I can now access the DBF files, but some of the field values are encrypted. Looks like I'd have to use the ACT! API to read these files...My Question now is. 1. Can I use the ACT! API to access flat files i.e .dbf, .ddf etc2. Could I use the ACT! 2005 API to read ACT! 6.0 dbf files. Since the 2005 API was developed in .NET, it's much easier to use... |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-26 : 13:43:12
|
You should ask these questions to ACT! tech support. I'm sure they understand this product better than anyone here.quote:
Originally posted by tchinedu...My Question now is. 1. Can I use the ACT! API to access flat files i.e .dbf, .ddf etc2. Could I use the ACT! 2005 API to read ACT! 6.0 dbf files. Since the 2005 API was developed in .NET, it's much easier to use...
CODO ERGO SUM |
|
|
|
|
|
|
|
|
uncompressing ACT! data fields