Solved

Connect Excel list to DBCombo in VB forms

Posted on 1999-01-29
1
479 Views
Last Modified: 2012-06-27
How connect a database list stored in excel worksheet to DBCombo control in VB form (Excel 97)?
0
Comment
Question by:aenede
1 Comment
 
LVL 3

Accepted Solution

by:
sduckett earned 200 total points
ID: 1616093
1. Put a data control on your form
2. For that controls Connect property, choose 'Excel 8.0'.
3. Property, DatabaseName = Your XL database file.
4. Property, RecordSource = The sheet in your xls
5. For your DBCombo, RowSource = Your Data control
6. For your DBCombo, ListField = Field on your XL sheet
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

937 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

4 Experts available now in Live!

Get 1:1 Help Now