More on importing dbf file into Microsoft Access 2007

I was puzzled for an hour about why the Microsoft Access 2007 kept complain that the file ThisIsMyDefiniteCatalog.dbf doesn't exist when I tried to open it. It turned out that the filename of a dbf file cannot be long than certain length (probably not more than 8 character since this is the file format inherited form the DOS days). After I change the file name to present.dbf, Access has no problem access the file.

Here's my procedure of getting Advance Disc Catalog database converted to a Access file which can be accessed by the Server Explorer in Visual Studio 2008:

• Export database form Advance Disc Catalog to .dbf foramt. Make sure you EXCLUDE comment when you export. Use a less than 8 character file name, like export.dbf.
  
• In Access 2007, create a new empty database. I chose .mdb format instead of the new format in case I need to access the database through Access 2003.
• Import data form the export.dbf file.
• Rename the imported table to something meaningful, like DiscCatalog.
• Save the newly created database.