ACC97: Importing/Linking Certain Files Via FTP Generates Error

ID: Q163624

The information in this article applies to:

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you import or link certain types of files from an FTP site in Microsoft Access 97, you may receive an error message.

If you try to import or link a table from a Microsoft Access database, you receive the following error message:

Not a valid file name.

If you try to link a dBASE table, you receive the following error message when you select an index file. Note that if you do not use an index, the table links successfully.
You cannot use an Internet address here. Enter a path that points to a location on your computer or on the network.

If you try to import or link a text file, you receive the following error message:
Bad file name or number


CAUSE

For text files, Microsoft Access uses an Open File command to populate the wizard with data; the Open File command does not support FTP.

For Microsoft Access databases, this behavior is by design. Microsoft Access does not support importing or linking a Microsoft Access database on an FTP server.

NOTE: Microsoft Access online Help explains that you cannot import or link via FTP to a Microsoft Access database; however, online Help does not mention that you cannot import or link text files via FTP. For Help topic locations, see the References section at the end of this article.


RESOLUTION

You can copy or move the file to a local hard disk, floppy disk, or network drive, and then import or link the file.

You can import a text file from an FTP site if you use the TransferText action or method and import the file through a macro or Visual Basic for Applications code.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97.


MORE INFORMATION

Steps to Reproduce Problem

The following example demonstrates the error by trying to import a text file.
  1. Create a text file on an FTP share.


  2. Start Microsoft Access and open the sample database Northwind.mdb.


  3. On the File menu, point to Get External Data, and then click Import.


  4. Type the path to your FTP server in the File Name box, for example, FTP://MyFTPServer.


  5. Select Text Files in the Files Of Type box.


  6. Select your text file, and click the Import button. Note that your receive the following error message:
    Bad file name or number



REFERENCES

For more information about importing or linking data from FTP sites, search the Help Index for "FTP sites, importing and linking files."

For more information about importing or linking data in Microsoft Access, search the Help Index for "importing data, importing data" or ask the Microsoft Access 97 Office Assistant.

Additional query words: attach 


Keywords          : kberrmsg kbinterop IsmTxtd IsmIea IsmXbase 
Version           : 97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 19, 1999