The database for Nomina Insecta Nearctica consists of three table; a species group name table, a genus group name table, and a family group name table. The family group name table is somewhat out of date. Only the tables for genera and species are included here.

The two tables are further subdivided into orders. This procedure was done for two reasons; to shorten the download sizes and times, and to provide useable chunks for those who are only interested in one or a few of the orders of the class Insecta.

The original database was compiled with the program Foxpro ® with the primary file extension of .dbf. However the most commonly used desktop databases are Microsoft Access® and Filemaker

Pro®. Therefore the files here are all in Microsoft Access 2003 with the file extension .mdf. These files are easily read with Microsoft Access 2007 ®. Also from Microsoft Access the files can be easily converted to both .dbf files and Microsoft Excel ®.

Filemake Pro cannot read or import Microsoft Access databases. The easiest way to convert one to the other is through Microsoft Excel. Convert the .mdf files to an Excel spreadsheet and then import the excel file into Filemaker Pro. The internet has several sites on the procedure if you need help.

Important Note: Whenever you convert a database or table from one file format to another, almost invariably the diacritical marks on authors' name are lost or converted into strange looking alternatives. You will probably have to go through the author fields and make the appropriate substitutions.

First create a directory to store the downloaded tables. Clicking on a link will bring up a Windows download message. Choose "Save To" and the table will be saved to the assigned directory.
Species Tables
Genera Tables
Anoplura
Archaeognatha
Blattodea
Coleoptera
Collembola
Dermaptera
Diplura
Diptera
Embioptera
Ephemeroptera
Grylloblattodea
Heteroptera
Homoptera
Hymenoptera
Isoptera
Lepidoptera
Mallophaga
Mantodea
Mecoptera
Megaloptera
Neuroptera
Odonata
Orthoptera
Phasmatodea
Plecoptera
Psocoptera
Raphidioptera
Siphonaptera
Strepsiptera
Thysanoptera
Thysanura
Trichoptera
Zoraptera
Anoplura
Archaeognatha
Blattodea
Coleoptera
Collembola
Dermaptera
Diplura
Diptera
Embioptera
Ephemeroptera
Grylloblattodea
Heteroptera
Homoptera
Hymenoptera
Isoptera
Lepidoptera
Mallophaga
Mantodea
Mecoptera
Megaloptera
Neuroptera
Odonata
Orthoptera
Phasmatodea
Plecoptera
Psocoptera
Raphidioptera
Siphonaptera
Strepsiptera
Thysanoptera
Thysanura
Trichoptera
Zoraptera