GR-FX - ODBC Testing

vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More

The Toolbox
Libraries of software that we regularly import into our projects. Enhances the Toolshed More..

DryToast New
Backup and query your BaseCampŽ projects
Read More

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new Expression Web
vb123.com.au

ODBC Testing Explained .. Š GR-FX P/L

This page shows how to test an an ODBC data source setup using Windows95 32bit ODBC. This testing is demonstrated by attaching to it in Excel and returning data into a spreadsheet.

Step 10: Start up Excel, locate the Data menu. Click on the Get External Data item on the sub menu. This will produce the Select Data Source dialog box of Microsoft Query. If this does not appear, you may have to install Data Access options as part of your installation of Excel ot Microsoft Office.

Step 11: Within the Select Data Source dialog box should be listed the data source previously defined. For this example it is KG1_Data. Highlight the data source name you wish to use and press the Use button. This will produce the Add Tables dialog box.

Step 12: Select the table(s) you wish to retrieve data from.

Step 13: For each table you wish to retrieve from, press the Add button.

Step 14: You will see the table with it's associated fields appear in the Query space.

Step 14: ODBC by SoftSkills

Step 15: When you have selected all the tables you require, press the Close button on the Add Tables dialog box. Then you can select,drag and drop the fields you want to retriev data for into the query columns below the tables.

Step 15: ODBC by SoftSkills

Step 16: When you are done selecting fields, highlight the Files menu of Microsoft Query, and highlight the Return Data to Microsoft Excel option.

Step 16: ODBC by SoftSkills

Step 17: Press OK on the Get External Data dialog box Excel will display.

Step 17: ODBC by SoftSkills

Step 18: This will then place the data retrieved from the tables and fields you nominated within the ODBC data source into columns in the spreadsheet headed by the field names.

Step 18: ODBC by SoftSkills

Click to buy the toolshed Click for help Return to the toolshed
Read part 1 of ODBC help