View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
vitz vitz is offline
external usenet poster
 
Posts: 3
Default Is it possible to link an Excel Workbook with a data base?

Hi I am vitz.
is there anybody knows how to querry data from *.aspx database using MS
excel (ver. 2003)?
Please help...

Is there a need for a driver, if so, what is it?
Thanks in advance..



"JLGWhiz" wrote:

That is outside my area of expertise. Maybe someone who works on the web
frequently can give you an answer.

"RyanH" wrote:

Sorry about the second question. This is what I had in mind. We currently
have a database that uses .net ( we can access the database from the
internet). I would like to figure out some way to set up a link on the data
base so when the user clicks the link the workbook along with all the macros
will be available to use.

Is something like this relatively easy or extremely complicated?

Thanks,
Ryan

"JLGWhiz" wrote:

This might get you started on the database question.

http://office.microsoft.com/en-us/ex...996671033.aspx

I don't understand the second question. Maybe if you stated the objective
it would help.

"RyanH" wrote:

I have two general questions. Sorry if this is vague!

1.) I have a Workbook with several macros that I use to calculate pricing
for our products. On the pricing sheet, I would like to access the database
so I can easily add customer information instead of cutting and pasting all
the time. Is this possible?

2.) Is it possible to open the same workbook with all the macros
operational with a link on a website?

Thanks in Advance,
Ryan