Troubleshoot importing and exporting business data in Business Contact Manager

ShowMy 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 (comma separated values file: A text file that contains data that is separated by commas (also known as a comma-delimited file). You can create and save a .csv file in programs such as Notepad or Excel.), and then import it into your Business Contact Manager database (Business Contact Manager database: The database that stores information about Accounts, Business Contacts, Opportunities, Business Projects, and other items.) 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.

ShowI 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 (Account: A business or organization with which you do business. If a service is being provided, such as dental or medical, an Account can also be a customer.) or Business Contacts (Business Contact: A person with whom you do business at a company or organization.) folders in Business Contact Manager for Outlook.

ShowWhen 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.

ShowWhen 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.

ShowWhy 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 (data type: A property of a field that defines the kinds of data the field can store.). 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.

ShowI 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.

ShowAfter 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.

ShowHow?

  1. In Excel 2007, open the file.
  2. Click the Microsoft Office Button  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).
  1. In Outlook, on the File menu, point to Import and Export, and then click Business Contact Manager for Outlook.
  2. In the Business Data Import and Export wizard, click Import a file.
  3. 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.

ShowWhen 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.

ShowI 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

ShowHow?

  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.

ShowHow?

  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.
 
 
Applies to:
Outlook 2007