One question! - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

One question!

One question!# Database - 数据库

s*a2099-12-03 08:12

1 楼

I want to Use Visual Basic to solve this problem:
I have some data to handle. The data is in Miscrosoft Excel worksheet.
I find the port between VB and Excel. But I do not know how to input data
from the worksheet to VB data form.
Can VB give me some date sheet for output? I need you give me some advice.
Maybe I am confused with some basic concept. If you would like, please give
some answer.
//thanks

m*t2099-12-03 08:12

2 楼

There is an ODBC driver coming with VB which deals with Excel files.

【在 s**a 的大作中提到】

: I want to Use Visual Basic to solve this problem:
: I have some data to handle. The data is in Miscrosoft Excel worksheet.
: I find the port between VB and Excel. But I do not know how to input data
: from the worksheet to VB data form.
: Can VB give me some date sheet for output? I need you give me some advice.
: Maybe I am confused with some basic concept. If you would like, please give
: some answer.
: //thanks

s*a2099-12-03 08:12

3 楼

what is ODBC? //wuwu. I do not know. Can you speak in more details/

【在 m******t 的大作中提到】

: There is an ODBC driver coming with VB which deals with Excel files.

s*e2099-12-03 08:12

4 楼

Just ODBC for Excel, install it, then you can manage the data in excel as any
other database table.

【在 s**a 的大作中提到】

: what is ODBC? //wuwu. I do not know. Can you speak in more details/

m*t2099-12-03 08:12

5 楼

Basically an ODBC driver process database access requests in standard
SQL format. It's hard to give a tutorial about ODBC in this one single
post. You might want to check out some introductry books.

【在 s**a 的大作中提到】

: what is ODBC? //wuwu. I do not know. Can you speak in more details/

w*h2099-12-03 08:12

6 楼

Come here:
http://www.microsoft.com/data/

【在 m******t 的大作中提到】

:
: Basically an ODBC driver process database access requests in standard
: SQL format. It's hard to give a tutorial about ODBC in this one single
: post. You might want to check out some introductry books.