Showing posts with label Export. Show all posts
Showing posts with label Export. Show all posts

Repairing Corrupt DBF File When You Are Unable To Export To MS Outlook 2000

The DBF (Database File) is the background file that stores the data in the dBase databases. This data can be exported to several other applications for different kinds of purposes. For example, you can export a DBF file containing list of contacts and their related details into MS Outlook. However, at times some issues crop up while you are performing the import. Most of them appear due to DBF file corruption. You should try to find out the exact cause of this problem and recover DBF file. If you are unable to do so, then you should use DBF repair software to repair DBF file.

Let us assume a related scenario in which you are trying to import a DBF file in MS Outlook 2000. The DBF import fails and you receive the following error message in the process:

"An error has occurred in the dBase translator while getting the contents of a file system.

The file "\.dbf" was not recognized. The dBase translator was unable to recognize this file. It could be the wrong file, a version of the file type which is not supported by this translator, or the file might be corrupt."

Cause:

One of the causes of this problem is due to the bugs in the current version of MS FoxPro/dBase.

Due to the bugs in the application, Outlook fails to read a value that is greater than 99 years in the DBF 'Last Modified Date' field. Some applications that create DBF reset the numeric value to 0 once it crosses 99 while some continue beyond 99. The definition of the DBF file format is ambiguous enough to allow such confusion. Usually MS Office programs accommodate such bugs by increasing the count beyond 99, but this is not followed by MS FoxPro and dBase.

Resolution:

To resolve this problem, you should perform the following methods:

- Apply hotfix to cover up for the bugs: You should download and install the Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) hotfix. This would solve the 'Last Modified Data' field problem.
- Use alternative file format: You should try to import the DBF file in another platform such as CSV (Comma Separated Values), MS Excel (.XLS), MS Access (.MDB), etc.

If the issue is still not resolved, that means the DBF is corrupt. In such cases, you should use a third-party DBF file repair software to repair DBF file. These read-only DBF recovery tools are very safe to use and do not overwrite the existing database file while scanning it.

The best DBF repair software, which repairs DBF created in dBase III-V versions for MS Visual FoxPro 6.0 to 9.0 versions, is Stellar Phoenix DBF Recovery. Compatible with Windows 7, Vista, Server 2003, XP, and 2000, this do-it-yourself software recovers DBF objects including table name, column name, column data type, etc.

Hot Game !!! Game (FR)

Microsoft Outlook Data Export Becomes Simple With Free CodeTwo Outlook Export

Are you one of those Microsoft Outlook users who have encountered difficulties with Outlook data export? The problem with doing export from Outlook using Import and Export Wizard is that sometimes not all of the fields can actually be exported. You are unable to e.g. export email messages from Outlook with the date field included. Another limitation of the Wizard turns out when you try to export custom fields from Outlook forms - they are in fact invisible for Import and Export Wizard. Consequently you won't be able to export e.g. Contacts with custom fields using built-in export feature (might be useful for e.g. exporting Outlook Contacts to Gmail). How to efficiently save Outlook data to a CSV file including user-defined fields? What is generally the best way to export Outlook data?

There's one simple, though a bit time-consuming and not very professional, trick to export Outlook folder with custom fields to Excel. Open the folder you want to export (e.g. Contacts) and switch to Table view (e.g. Phone List). Make sure that you have your custom fields listed (use Show Fields dialog to pick the fields you want to display). Now select all the items you would like to export, then copy and paste them directly into an Excel worksheet. That's it. However, if you need more (or any) control over exporting and you want to do this in a quicker and easier way - continue reading this article.

Another solution is to automate the process with the use of VBA. If you know how to create macros you will deal with the problem with a few keystrokes. If you don't - keep reading this article.

The easiest and fastest way is to use third party software to export Outlook data.

Good things in life are free - and so is an easy-to-use freeware application called CodeTwo Outlook Export. In short: it allows quick and advanced export of data from Microsoft Outlook to CSV text files. You can easily export your Contacts, Calendar, E-mail, Post, Tasks, Journal, Notes together with non-standard user-defined fields from Outlook. CodeTwo Outlook Export is quicker and easier to use than the built-in export feature in Outlook. Additionally, it allows you to export data from public folders (by the way, did you know that you can share Outlook folders without Exchange using another CodeTwo application, CodeTwo Public Folders?)

After installing the program, the new icon will appear in the standard Outlook toolbar. Click it to run CodeTwo Outlook Export. Working with the program is pretty intuitive. Start by choosing whether to export data from all items in the current folder or to export only selected items. The Add button displays the Field chooser dialog. It allows you to decide which fields of data will be exported to a CSV file. The Field chooser dialog box displays a variety of fields, depending on the folder type, which the data is currently exported from. That's all you need to do to gain full control over exporting data from Outlook.

CodeTwo Outlook Export works with Microsoft Outlook 2007 / 2003 / 2002 / 2000 / 98. Download it for free from CodeTwo web site and have your Outlook export problem fixed. CodeTwo Outlook Export is an optimal Outlook exporting solution, when you need more fields to be exported, include custom fields in export, export data from Public Folders, or just equip Outlook with a more efficient export feature.

Hot Game !!!