Importing the Download File Into Microsoft Access
Please note: We provide this information as a
free service to guide you in using our information. However, we do not sell
Microsoft Access and therefore cannot provide technical support for it.
1. First, use mnileads.com to select the companies you want and download them to
your computer. For text file options, leave the default choices selected: Yes
for Field Names as First Record, Commas for the Quoted Field Delimiter. The
result will be a .TXT file (Example: MNI403062797105112.TXT).
2. Next, launch Microsoft Access.
3. Click Blank Database, then click OK.
4. Select a location to save the database, and type a name for your new database
(Example: DATA.MDB). Click Create.
5. Click on File and choose Get External Data… Import… from the menu.
6. In the Files Of Type: box, choose Text Files.
7. Then find the exported file (Example: MNI403062797105112.TXT) and
double-click on it. The Import Text Wizard will be displayed.
8. In step 1 of the Text Import Wizard, select Delimited, then click Next.
9. Make sure that Comma is selected, check the First Row Contains Field Names
box, then click Next.
10. Click Next again.
11. Format any fields that may contain 0 as a first digit as Text. These fields
may include (but are not limited to) zip codes, telephone and fax numbers, and
SIC codes. (Note: experienced Access users may choose a more specific format for
these particular fields if they wish.) Click Next.
12. Select Choose my own Primary Key, and choose the Company ID field from the
drop-down list.
13. Click Next.
14. Click Finish. The resulting table contains all the data from the file.
You are finished importing the file into Access. Your Access database is ready
to use.
For a list of the fields in the table, point your browser to
http://www.mnileads.com/pages/fields.asp.