excel vba courses - excel external data
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - Excel External Data

Recommend training98.1 %
recommend us
More live stats...

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

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

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 vba courses - Excel External Data

resolvedResolved · Low Priority · Version Standard

replyReply Tue 20 Nov 2007, 16:09Delegate daniel said...

daniel has attended:
Excel Intermediate course

Excel External Data

How to merge database from Access into Excel spreadsheet?

For upcoming training course dates see: Pricing & availability

replyReply Wed 21 Nov 2007, 14:38Trainer Stephen said...

RE: Excel External Data

Hi Daniel

Thanks for your question.

You can export data from either from an Access Query or Table into Excel pretty easily.

Simply open the Access database and go to the database window. Right click on the table or query and from the resulting context menu select export. You will then be prompted to identify the format you wish to use; in this instance you would select the relevant version of Excel and then click export.

A new workbook will then be created and the data exported to it.

Regards

Stephen

 

Excel articles

· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· Charting Your Success With Excel 2007
· Automatically Insert The Time, Date Or Both In Excel
· Avoid Duplication In Excel By Ensuring Unique Values
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy