access courses in london - Importing Tables

Resolved · Low Priority · Version Standard

Importing Tables

Stuart has attended:
Access Consulting course

by - delegate Stuart [4 posts] (2007 Oct 8 Mon, 16:48) Reply

I know this was covered in the course but could you remind me how to imort an existing Exel file into Access?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Importing Tables

by - trainer Carlos gold contributer [479 posts] (2007 Oct 9 Tue, 09:31) Reply

Hi Stuart

To import an excel file into Access do the following:

1. Make sure the Excel file is saved in a folder you have access to.

2. Start Microsoft Access and open the database you want to import the Excel information into.

3. Open the File menu, click Get External Data and then click Import.

4. In the Import dialog box, select Microsoft Excel (*.xls) in the Files Of Type option. (This will display only the Microsoft Excel files)

5. Find the desired file and click the Import button.

The Import Spreadsheet Wizard appears and allows you to choose options specific to the file.

Hope this helps

Carlos