Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel vba - Importing Data

best training excel vba - Importing Data

ResolvedVersion Standard

Fri 1 Feb 2008, 16:41 Delegate Jane said...

Jane has attended:
Excel Intermediate course
Excel Advanced course

Importing Data

Is it possible to import from an Access 97 database to Excel 2003? If so are there any restrictions?

Sun 10 Feb 2008, 11:21 Trainer Stephen said...

RE: Importing Data

Hi Jane,

Thank you for your question

There should be no difficulty in importing the data you need.

Simply click on data-import external data-Import Data

In the file type combo box select Access database and then locate the file on your system. You will then be given a list of tables and queries from which to select the required data.

Another option is to choose data-import external data-New Database Query, this then gives you a list of file types to import from and specifically includes access 97 databases.

Hope this is useful

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using the Quick Access Toolbar in Excel2010

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 Excel hints and tips

best training excel vba - Importing Data

Importing Data

RE: Importing Data

Excel articles

Excel tip:

Using the Quick Access Toolbar in Excel2010