Home | Contact Us | Help

Import Data Into Microsoft Access 2002

Import Data Below is brief a tutorial on the subject of importing your mailing list into Microsoft Access.
The standard way in which we supply data is in Microsoft Excel as an email attachment. After saving your mailing list to the hard drive, you can import the data into access by following these simple instructions below.

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".

Figure 1

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.

Figure 2

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.

Figure 3

4. Tick the 'First Row Contains Column Headings' and click "Next". In the next dialog box check the 'In a New Table' radio button and click "Next" again.

Figure 4

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.

Figure 5

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".

Figure 6

More Tutorials

Who we have worked with, both past and present;

Who we have worked with, both past and present
Sign up to our monthly newsletter here  

Whichlist.com is operated by Spartacus Marketing Ltd
Consumer Mailing Lists | Business Mailing Lists | Email Design | Email Broadcasting | UK Postcode Map