Fill Data from Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dmmitchell@gmail.com - 07 Jun 2006 19:54 GMT

Hello ---

I am an intern at a company this summer, trying to create an excel
spreadsheet that would access information from a database (or even
another excel spreadsheet) once I enter one piece of information...
Example: Completing an internal order form -- if I enter the company
name, can Excel load the information of the company, including rates
for products, like advertising spots?)

Any help would be greatly appreciated...

Derek

Reply to this Message

mrice - 07 Jun 2006 20:03 GMT

If you link a macro to the change event of the cell of box that you ar
filling with the company name, you should be able to do what you want

--
mric

Research Scientist with many years of spreadsheet development experienc

Reply to this Message

dmmitchell@gmail.com - 07 Jun 2006 20:16 GMT

Could you possibly elaborate as to how to do that?

Derek

> If you link a macro to the change event of the cell of box that you are
> filling with the company name, you should be able to do what you want.
[quoted text clipped - 6 lines]
> mrice's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10931
> View this thread: http://www.excelforum.com/showthread.php?threadid=549642

Reply to this Message

Ryan.Chowdhury@gmail.com - 07 Jun 2006 23:00 GMT

You can use traditional index, offsets, or vlookups if the data is in
another Excel worksheet. If there is a dataset from a database that I
want to do a lot of calculations on what I usually do is setup a new
tab that brings in the database data using the Data > Import External
Data menu item.

> Hello ---
>
[quoted text clipped - 8 lines]
>
> Derek

Reply to this Message

dbahooker@hotmail.com - 08 Jun 2006 00:56 GMT

1) throw away Excel
2) spit on anyone that uses Excel for anything
3) build it in a database; this is a simple query in access from what
you're describing.
1. get your tables straight
2. build a query
3. bind it to one of the where clauses to point to the form and the
control where you will select data.

no coding; no macros.

no complicated formulas.

and it will work for hundreds; thousands of customers if you want.

even millions of customers.

-Aaron

> You can use traditional index, offsets, or vlookups if the data is in
> another Excel worksheet. If there is a dataset from a database that I
[quoted text clipped - 14 lines]
> >
> > Derek

Reply to this Message

Joao Saraiva - 08 Jun 2006 22:32 GMT

again you must be delighted with the "quality" of your piece of advice ...
congratulation if that makes you happy !

just wonder why do you bother to read this newsgroup if you dislike excel so
much ???

> 1) throw away Excel
> 2) spit on anyone that uses Excel for anything
[quoted text clipped - 33 lines]
> > >
> > > Derek

Reply to this Message