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.
Microsoft ExcelMicrosoft OfficeVisual Basic Classic

Avatar of undefined
Last Comment
JCWEBHOST

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Patrick Matthews

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck