Below is brief tutorial on the subjects
of saving your data to your hard disk and then importing
it into Microsoft Access. The standard way in which Direct
Marketing Lists supply data is in Microsoft Excel as an
email attachment. Using Microsoft Access is an easy &
effective way of querying and manipulating the data.
Saving Your Mailing Lists To
Your Hard Disk
1.Open the email that has the data
attached. Place you mouse curser over the attachment
and right click on it. From the drop down menu click
"Save As...".
2. The 'Save Attachment'
dialog box appears & 'My Documents'
is selected by default. If you wish to rename your file
you can do so in the "File Name:"
box at the bottom. If you wish to save the file somewhere
different to the 'My Documents' folder,
navigate to the desired folder. Click "Save"
in the bottom right corner. That's it your data is now
saved to the My documents folder on your hard disk.
Importing You Data Into Microsoft
Access 2002
1.Open the database that you wish
to import the data into. Click "File"
(on the top toolbar), "Get External
Data" and the click "Import".
2. The 'Import'
dialog box appears and again 'My Documents'
is the default folder. Select "Microsoft
Excel" from the 'Files of type:'
drop down menu at the bottom of the dialog box. The Excel
file that you saved earlier appears. Click the Excel file
once, then click the "Import"
button. Alternatively you can just double click the Excel
file.
3. The 'Import
Spreadsheet Wizard' dialog box opens. Ensure
that the 'Show Worksheets' radio button
is checked and click "Next"
in the bottom right of the box.
4. Tick the 'First
Row Contains Column Headings' and click "Next".
In the nxt dialog box check the 'In a New Table'
radio button and click "Next"
again.
5. Click "Next"
once more. Check the "No primary key"
radio button and click "Next". You can add a
primary key at a later date if you need to.
6. Click in the 'Import
to Table:' box and type the name that you wish
to call your imported file. Click "Finish"
and then click "OK".
