SBFM: Cannot Use UNC Connections When Importing Data

• Microsoft Small Business Financial Manager

SYMPTOMS

In the Microsoft Small Business Financial Manager (SBFM), when you use the Import Wizard to import accounting files, you are unable to type a UNC path into the Step 2 dialog box.

CAUSE

This behavior is by design of the Microsoft Small Business Financial Manager (SBFM).

WORKAROUND

To import files that are stored on a server, you must first map a drive letter to the appropriate network path. To do this, follow these steps:

1. If the Import Wizard is currently visible on the screen, click Cancel.



2. On the Start menu, point to Programs, and then click Windows Explorer.



3. On the Tools menu, click Map Network Drive.
   
   The Map Network Drive dialog box appears.



4. In the Drive box, click any available drive letter. Then, in the Path box, type the UNC path for the server to which you are trying to map.



5. Click OK.



6. On the File menu, click Close.

MORE INFORMATION

The Import Wizard included with the Microsoft Small Business Financial Manager allows you to import accounting files into Microsoft Excel.

If you choose to Import an accounting file into Microsoft Excel, the Step 2 dialog box of the Import Wizard, which allows you to determine where the SBFM will search for accounting files, will not allow you to enter a UNC (Universal Naming Convention) path to the files you want to import. The dialog box only allows you to choose from a list of already-mapped drive letters.

For example, if your accounting files are stored in a folder called Acctfils on the server Adastra, the UNC path for the files would be \\Adastra\Acctfils. You cannot enter this path into the Step 2 dialog box.

When you use the Import Wizard to import your files, choose the appropriate drive letter from the list of drives in the Step 2 dialog box. Once you are finished importing files, you can remove the mapped the drive letters. To do this, on the Tools menu in Windows Explorer, click Disconnect Network Drive.

For more information about how to perform this task in Windows, see your Windows printed documentation or online Help.

Additional query words: 7.00 SBFM 2.0 1.0 XL97

Keywords : xlwin
Version : :
Platform : WINDOWS
Issue type :