Is it possible to link an Excel Workbook with a data base?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RyanH - 23 May 2008 03:12 GMT

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

Reply to this Message

JLGWhiz - 23 May 2008 03:42 GMT

This might get you started on the database question.

http://office.microsoft.com/en-us/excel/HP100996671033.aspx

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

> I have two general questions. Sorry if this is vague!
>
[quoted text clipped - 8 lines]
> Thanks in Advance,
> Ryan

Reply to this Message

RyanH - 23 May 2008 12:35 GMT

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

> This might get you started on the database question.
>
[quoted text clipped - 15 lines]
> > Thanks in Advance,
> > Ryan

Reply to this Message

JLGWhiz - 23 May 2008 14:47 GMT

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

> 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
[quoted text clipped - 26 lines]
> > > Thanks in Advance,
> > > Ryan

Reply to this Message

vitz - 27 May 2008 03:49 GMT

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..

> That is outside my area of expertise. Maybe someone who works on the web
> frequently can give you an answer.
[quoted text clipped - 29 lines]
> > > > Thanks in Advance,
> > > > Ryan

Reply to this Message