excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 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.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips


Server loaded in 0.09 secs.