使用VB6在Excel数据库中搜索 [英] Searching in Excel Database Using VB6

问题描述

请帮助我使用VB进行编码，该VB在表单上具有以下输入:

以表格形式输入:
1>手机号码:对应的是一个文本框
2>呼叫来源:对应的是一个下拉框，其中的选项分别为MOC(移动始发呼叫)和TOC(中继始发呼叫)
3>要处理的树:对应的是一个文本框，其中默认值设置为Tree2.用户无法在其中输入任何其他值，否则应提示错误

我希望我的输出在列表框中进行预分析处理
以及修改后的10位数手机号码

当用户输入手机号码或座机号码时.在第一个输入中，例如+919920 ......，并从第二个输入中选择MOC呼叫类型，它将根据输入的内容在相关的MS-excel数据库中搜索呼叫列的类型，并按No.删除了数字列，并显示了一个10位数的手机号码.切断国家/地区代码后，在列表框中显示.

请帮助

Hi,

please help me to code using VB which has the following inputs on a form:

INPUTS IN A FORM:
1>Mobile no: corresponding to it is a textbox
2>Call Origin: corresponding to it is a drop-down box in which option re as MOC(Mobile Originated Call) and TOC(Trunk Originated Call)
3>Tree to be processed: corresponding to it is a textbox in which default value is set as Tree2.user cannot enter any other value in it else it should prompt for an error

I want my output in a list box as pre-analysis processed
and a modified 10 digit mobile no.

when user enters a mobile no or landline no. in 1st input for e.g +919920...... and selects MOC type of call from 2nd input it will search in relevant MS-excel database the type of call column according to input entered and chop the digits as specified in No. of removed digits column and display me a 10 digit mobile no. in listbox after cutting off the country code.

Please help

推荐答案

最简单的方法是连接到Excel电子表格，就好像它是数据库

The simplest way would be to connect to the Excel spreadsheet as if it were a database using ADO.


Then write SQL to get the data you want.

这篇关于使用VB6在Excel数据库中搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！