Have you tried using MS Query?:
DataImport External DataNew Database Query
....then follow the prompts.

Does that help?

***********
Regards,
Ron


"Stanley" wrote:

Does anyone know of a good tutorial on how to pull data from a database via
an ODBC connection? Is this possible in Excel 2000 or just in 2003? The basic
idea of the project I am working on is to pull data from a database and
populate our excel spreadsheet that does various calculations and then is
redistributed through out the company and partners after pasting just the
values.