Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

Sharon has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel

How do I import data from an Access database?

Thank you,

Sharon.

RE: Excel

Hi Sharon

There are a few answers to this. I think its easier to point you in the direction of the link below which gives you some really clear help with picture examples.

This is based on 2007. Let me know if this does not help.

Thanks
Paul

http://office.microsoft.com/en-us/excel-help/exchange-copy-import-export-data-between-excel-and-access-HA010096300.aspx

Tue 1 Nov 2011: Automatically marked as resolved.

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.