Scroll To Top

Enter a query to search our site. Note that you can use "*" and "?" as wildcards. Enclosing more than one word in double quotes ("CSS Layout") will search for the exact phrase.

PVII Knowledge Base

1. Select a product ...
2. Select category ...
3. Search the Knowledge Base...

Question #50

How can I add (import) external data from another database or spreadsheet into the Il Formaggio database?

The Answer

Prepared Oct. 2000 by Gerry Jacobsen, PVII

To add external data to the Formaggio database:

  1. Open the Formaggio database in Access
  2. Choose File>Get External Data
  3. Select Import. A Wizard will prompt you for the external data source, either another db or a spreadsheet
  4. Follow the on-screen prompts to import the data to the table(s) that you desire.

You can Import data from any other data source on your system including text files, Excel or Lotus spreadsheets, any database that you have running on your system.

Back to the questions list