Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft-access-course - Import data

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft-access-course - Import data

Resolved · Low Priority · Version Standard

Reply Mon 23 Apr 2007, 09:46Delegate Anne said...

Anne has attended:
Access Introduction course

Import data

How do I import data from excel to access?

For upcoming training course dates see: Pricing & availability

Reply Mon 23 Apr 2007, 10:05Trainer Richard said...

RE: Import data

Hi Anne

Simply click on File > Get external data> Import

Then point to the file that you want to import and follow the Import wizard.
You will need to select:
- what sheet you want
- any delimiters
- formatting
- location

Once that is complete, then Access creates a new table with your imported data.

Regards

Richard

Access articles

· So You Still Haven't Learned How To Use Access Yet?
· Want To Find Out About Access Queries?
· Why go on a Microsoft Access Training Course?
· How To Use Lookups For Data Entry In Microsoft Access
· Record, Find And View Data Easily Thanks To Microsoft Access

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy