Importing .DBF File SQL Server 2008 64 Bit

pepps11976
pepps11976 used Ask the Experts™
on
hi all i have a .dbf file that i need to be able to import into sql, the file is an old ACT database.

can anybody assist me in doing this, im pretty new with the whole import thing

john
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You may need to upgrade the ACT database from the dbase format to SQL Server which involves upgrading (I believe) to ACT version 8. That should convert the database to a SQL Server database which you can then attach. You may also need the sa password tool to remove the sa password on the database. I know ACT a little bit so I may be incorrect on the sa password bit and the version.

Author

Commented:
Thans for the info is upgrading the only way to do this because we do not use act anymore so would not really want to get involved in the costs of upgrading for something that we will not use.

You say you know ACT a little bit if i tell you what i want you might know a better way to do it, basically i would like to export all the contacts out so they can still be accessed if needed, and i would also want all the notes/history save aswell.

What do you think

John
Well, in theory you can use a trial version of ACT from here which costs nothing:

https://support.sage.co.uk/default.aspx?page=22&did=ae7a3979-e5ad-484c-8364-5302463ead8c

It might be best to press the "Request Attention" on this question to get it put in the ACT zone:

http://www.experts-exchange.com/Database/Contact_Management/ACT/

They'd know more than i would about ACT but this is the way to do it. Get ACT to upgrade its database for you then you cna simply attach it to SQL.

Author

Commented:
Thanks for your help  lsavidge

you will not be forgotten when awarding points :)
Mike LazarusAct! Evangelist - CRM Consultant
Commented:
Question: Do you just want the contact fields ... or do you want notes, history, activities, etc?
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

Commented:
on old act databases, notes and history were always difficult to import. there are some interesting links and joins you have to go through.

simply upgrading to the SQL version may not help - they do make elements of it specially difficult.

I used to use a third party tool that could export all the required information, and then import that.

But it really does depend a bit on what version you have... Which is ?
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

Commented:
Oh, and if contacts primarily, you can use Outlook to import using Business Contact Manager : http://office.microsoft.com/en-us/outlook-help/import-a-file-into-business-contact-manager-HP001113507.aspx and the business contact manager database is an SQL database and you can then import into your live / production area.

Author

Commented:
i would like to export the contacts and all the notes and history assigned to thise contacts, i am currently using Act 6.0
Mike LazarusAct! Evangelist - CRM Consultant
Commented:
If you need all the Notes and History, that's much more tricky...
The easiest way is with something like itExport: http://www.glcomputing.com.au/main/69/2

If you get a trial version of ACT! 2011, then you could do it via OLEDB as per:
http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html
If this is truly a .dbf, i.e. a DBase formatted file, then there are several free tools that might help.

Here's one link:
DBF Viewer/Editor
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
The ACT! 6.0 contacts are in a DBF file. The notes/History are in seperate DBF files... but the regarding data is stored in a BLB file that is not standard

Author

Commented:
I would likento be able to export it so that all the contacts are still linked to the history do these optionsbsupport this
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018
Commented:
Most of the better third party tools will provide the required results - likely to be as seperate files which can then be imported quite readily.

A few examples of (paid for) tools :

http://www.glcomputing.com.au/main/69/2       (note the name and the expert above :) )

http://www.crmaddons.com/p-15-export-pro.aspx

http://www.jltechnical.com/exporter.htm

http://www.actaddons.com/products/123-act-to-csv-export.asp


I havent found any free tools that I could recommend that actually do the full job. All the above support ACT 6.0 and I have used one or two of them in the past.

I personally prefer exports to Excel or Access because I have run into a couple of CSV challenges in the past.

The relatively small investment in proven third party products are well worth the expense - even more so if it is to be repeated, or you have a few databases to convert (they seem to crawl out of the woodwork when you start to take it away).

Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

Commented:
Oh, and if you are handy with SQL, then a reminder about the other experts (lsavidge and glcomputing) suggestions of upgrading to a trial version of ACT.

I have never gone down that route from the earlier versions, but have connected once in SQL Server using Actreader : http://kb.sagesoftwareonline.com/app/answers/detail/a_id/22989 there is also a list of tables and columns : http://kb.sagesoftwareonline.com/app/answers/detail/a_id/22924 and note that actreader gives only read access to "most" data elements (certainly been enough from my experience).

Maybe lsavidge and glcomputing can provide more details on direct SQL connections.
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
Re ActReader:
1. Only available with the Premium version
2. Is far more complex than the OLEDB views

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial