access+training - Uploading data from excel

Resolved · Low Priority · Version Standard

Uploading data from excel

Zehra has attended:
Access Intermediate course
Access Advanced course

by - delegate Zehra [3 posts] (2008 Jan 24 Thu, 15:14) Reply

How do you upload data from excel?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	0	FULL
2003	2009 Jan 8 Thu + 9 Fri	Southwark	5	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Uploading data from excel

by - trainer Carlos gold contributer [479 posts] (2008 Jan 28 Mon, 12:23) Reply

Hi Zehra

If you have data on an Excel worksheet that is needed in an Access Database you import the Excel table. To do this :

NB Before doing this make sure the table being imported from Excel is correctly setup. (ie Row 1 must contain the Column headings / Field names)

1. Open the File Menu and select Get External Data. In the sub menu select Import

2. The Import dialog box appears

3. Find the folder that contains the required Excel workbook

3. In the Files Of Type select Excel

4. Select the name of the Workbook to be imported
5. Click Import

6. The Import Spreadsheets Wizard appears. Go through to the finish and fix anything that is required.

7. When done click Finish

A new table appears in the database.

Hope this helps

Carlos