My data is saved in a file format that is not listed in the Business Data Import and Export wizard
I can't import my Windows Live Mail data into 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:
|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.
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:
- Save the Excel* file as a comma separated values file.
- In Excel 2007, open the file.
- Click the Microsoft Office Button .
- Point to Save As, and then click Other Formats.
- In the Save As dialog box, in the Save as type list, click CSV (Comma delimited) (*.csv).
- In Outlook, on the File menu, point to Import and Export, and then click Business Contact Manager for Outlook.
- In the Business Data Import and Export wizard, click Import a file.
- 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
- Right-click the Account or Business Contact record
- 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.
- On the Business Contact Manager menu, point to Database Tools, and then click Import and Export.
- In the Business Data Import and Export wizard, click Export a file, and then click Next.
- Click the type of file to export to, and then click Next.
- On the Select the data you want to export page, click Business Contacts and Leads or Accounts.
- Select the Select specific records of the type specified above check box, and then click Select.
- Click the Review Results tab.
- Select the check box of the record that you want to export, and then click OK.
- Click Next, and then complete the Business Data Import and Export wizard.