Troubleshoot importing and exporting business data in Business Contact Manager

My data is saved in a file format that is not listed in the Business Data Import and Export wizard

If your data is saved in a file format that is not listed in the Business Data Import and Export wizard, save the data as comma separated values file, and then import it into your Business Contact Manager database by using the Business Data Import and Export wizard.

To use Office 2003 programs to open documents created by using 2007 Office system file formats such as .xslx, download the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 file formats from the Microsoft Web site.

I can't import my Windows Live Mail data into Business Contact Manager for Outlook

To import your Windows Live Mail data into Business Contact Manager for Outlook, you must first add your Windows Live Mail account to Outlook. To add your Windows Live account to Outlook, see Add or remove an e-mail account.

After you have added your Windows Live Mail account to Outlook, you can import your data to the Accounts or Business Contacts folders in Business Contact Manager for Outlook.

When importing data, the Import Status window is blank or shows the message of Not Responding

When Business Contact Manager for Outlook imports a large database, the status window might show the progress of the import process improperly. Although the status window is blank or shows the message of Not Responding, Business Contact Manager for Outlook is still importing your data.

When importing a comma-separated values (.csv) file, I receive a message stating that there was an incorrect number of columns in the input file

Ensure that the comma-separated values (.csv) file that you are importing uses commas (or the list separator found in your Windows operating system, in Control Panel, in the Date, Time, Language, and Regional Options category, in the Regional and Language Options dialog box, on the Regional Options tab), and then import the file again.

Why did the import of my comma-separated values (.csv) file not succeed?

Possible causes why the import of your comma-separated values (.csv) file did not succeed are listed in the following table:

Cause

Solution

Columns have no labels or headers.

Add a label or column header to each data type. Importing the data will be simpler if you can use a label or column header that currently exists in the Business Contact Manager database.

Column labels or headers are not unique.

Check for duplicate labels or headers and make them unique. For example, if there are two labels or headers called Phone Number, make one Phone Number 1, and the other Phone Number 2

The .csv file contains non-printable characters.

Non-printable characters include line returns, and page or section breaks. Ensure all of these are deleted before you try importing the file again.

I can't import my ANSI file format

Business Contact Manager for Outlook supports only the Unicode file format. The ANSI file format isn't supported.

After I import business data, some of my phone numbers do not appear

This is a known issue when importing business data in an Excel* file format. Try the following:

  1. Save the Excel* file as a comma separated values file.

    How?

    1. In Excel 2007, open the file.

    2. Click the Microsoft Office Button   Office button image .

    3. Point to Save As, and then click Other Formats.

    4. In the Save As dialog box, in the Save as type list, click CSV (Comma delimited) (*.csv).

  2. In Outlook, on the File menu, point to Import and Export, and then click Business Contact Manager for Outlook.

  3. In the Business Data Import and Export wizard, click Import a file.

  4. Select Comma-separated values (.csv), select whether or not to import duplicate records, and then click Next to import the data.

*The stand-alone edition of Microsoft Office Outlook 2007 with Business Contact Manager can be used with Excel 2007 or 2003. For information about how to save an Excel 2003 file as a comma separated values file, see Help in Excel 2003.

When I imported an Account or Business Contact, the linked Business Contact record or Account record was not imported with it

When you import Accounts or Business Contacts, you can choose to import all the records, including the related communication history, or you can choose to import only the records you want. When you import selected Account or Business Contact records, their respective linked Business Contacts or Accounts are not imported.

I want to export a single Account or Business Contact record

To export a single Account or Business Contact record, do one of the following:

  • Send the record in an e-mail message

    How?

    1. Right-click the Account or Business Contact record

    2. Point to Send Full Account or Send Full Business Contact, and then click In Outlook Format.

      An e-mail message opens with the record attached.

      Note: The Account or Business Contact record is attached as Outlook contact.

  • Export the record using the Business Data Import and Export wizard.

    How?

    1. On the Business Contact Manager menu, point to Database Tools, and then click Import and Export.

    2. In the Business Data Import and Export wizard, click Export a file, and then click Next.

    3. Click the type of file to export to, and then click Next.

    4. On the Select the data you want to export page, click Business Contacts and Leads or Accounts.

    5. Select the Select specific records of the type specified above check box, and then click Select.

    6. Click the Review Results tab.

    7. Select the check box of the record that you want to export, and then click OK.

    8. Click Next, and then complete the Business Data Import and Export wizard.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×