Link to home
Start Free TrialLog in
Avatar of JCWEBHOST
JCWEBHOST

asked on

excel database

hey guys i want to know if this is possirable with excel?

i want the user to insert information into the cell and coloums of excel document and insert into a database, the problem come when populating a coloum with like a dropdown selection where the user can insert any number of rows has long has it is in the right coloum.


i have found out how to use vba in excel and know how to insert i line and cells into a database, my problem is unknow rows and how to fomat a cell like a dropdown from a database.

or yes and is it possirable that each time a move to the next row that a new line to insert a record.

i know it is hard to do but its my client request.
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JCWEBHOST
JCWEBHOST

ASKER

can you show me an exsample which allows the user to input information and pupulate a coloum from database.

the point is to get the user the easy enter information in throuht excel