Linking SQL database to MS Project 2000

[Geoff]

Hello, I work for a company which manufacture solenoid valves.

We have a new MRP system that holds part numbers, costs, customers,
orders, stock etc.
The backbone to this system is a SQL database.

Now this is what I would like to achive.

Start a new project plan,

Compile a new parts list for a special valve.

Have MS project tell me the stock availabiliy, location and COGS for
each part I select, so I can swap and change to achive a desired cost
for the valve.

Could this be achived without importing the required data, so the
project would be reading live data?

Lets say the fields are as follow

PART_NO
COGS
STOCK_ID
STOCK_QTY

and the database is called SQL_Database

What would the VBA look like?

Thank you for your time.

Geoff