accessing SQL 2000 table from within Excel

Hi,

I have a need to process a column of data and get information from SQL
2000 and return it to the Excel Spread Sheet.

The data will be a list of order numbers in column 1. I need to look
up each order number and return infomration relating to the order from
SQL.

Can anyone point me to the right process?

thanks in advance,Tim <tbertw@.n-o-s-p-a-m.tenbuckplans.com> wrote in message news:<k6qrb0p2jet65kcm67fia0f5fptgsf8fia@.4ax.com>...
> Hi,
> I have a need to process a column of data and get information from SQL
> 2000 and return it to the Excel Spread Sheet.
> The data will be a list of order numbers in column 1. I need to look
> up each order number and return infomration relating to the order from
> SQL.
> Can anyone point me to the right process?
> thanks in advance,

Data menu - Get External Data - New Database Query, then create a new
source or use an existing one to connect to the server. Or at least
that works for Excel 2000 - you didn't mention which version you have.

Simon