This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

技多不压身，工到自然成：安省技工证书特训班，点击咨询报名！

Ad by

技多不压身，工到自然成：安省技工证书特训班，点击咨询报名！

You must have correct connection string. such as..

schen(糊涂阿福)

oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=c:\somepath\mySpreadsheet.xls;" & _
"DefaultDir=c:\somepath"

check http://www.able-consulting.com/ADO_Conn.htm for details

http://www.able-consulting.com/ADO_Conn.htm

(#1657598@0)
Last Updated: 2004-3-24
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / IT技术讨论 / 请教：把EXCEL做DATABASE，用ODBC，在VB中怎样写SQL语句来提取数据：SELECT * FROM ？？？？？？或能不能这样做？谢谢！ -jang(jang); 2004-3-24 (#1657070@0)

Never tried, don't think so. -charleslike(Unionville-愚人); 2004-3-24 (#1657072@0)

谢谢！那奇怪为什么在ODBC中又允许EXCEL做数据源？ -jang(jang); 2004-3-24 (#1657095@0)

Sorry, it is ok, just tested. -charleslike(Unionville-愚人); 2004-3-24 (#1657119@0)

How? -jang(jang); 2004-3-24 (#1657122@0)

ADO -canadiantire(Crappy Tire); 2004-3-24 (#1657098@0)

yes, i'm using ADO. just don't know the syntax of SQL for EXCEL. Thanks. -jang(jang); 2004-3-24 (#1657130@0)

可以。。sheet name就是表名 -expertune(伪劣); 2004-3-24 (#1657102@0)

对了，sheetname后面要加个!还是 $，忘了。。。 -expertune(伪劣); 2004-3-24 (#1657109@0)

Not working. Thanks. -jang(jang); 2004-3-24 (#1657123@0)

Here is how: -canadiantire(Crappy Tire); 2004-3-24 {278} (#1657212@0)
insert MS DAO from Reference, name the column your want to select (named range) as, for example, "mycol"

Dim db as DAO.Database
Dim rs as DAO.Recordset

set db = OpenDatabase("myfile.xls", , "Excel 8.0")
set rs = db.OpenRecordset("SELECT * from mycol ")
...

Thanks. It doesn't work. Error: unrecognized database format. -jang(jang); 2004-3-24 (#1657419@0)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate_topic4.asp -canadiantire(Crappy Tire); 2004-3-24 {432} (#1657438@0)
Database String
dBASE III dBASE III;
dBASE IV dBASE IV;
dBASE 5 dBASE 5.0;
Paradox 3.x Paradox 3.x;
Paradox 4.x Paradox 4.x;
Paradox 5.x Paradox 5.x;
Excel 3.0 Excel 3.0;
Excel 4.0 Excel 4.0;
Excel 5.0/Excel 95 Excel 5.0;
Excel 97 Excel 97;
Excel 2000 Excel 8.0;
HTML Import HTML Import;
HTML Export HTML Export;
Text Text;
ODBC ODBC;
DATABASE=database;
UID=user;
PWD=password;
DSN=datasourcename;

Ah, at last, I made it. The syntax is: "select * from [sheetname$]". Many thanks to everyone! -jang(jang); 2004-3-24 (#1657582@0)
You must have correct connection string. such as.. -schen(糊涂阿福); 2004-3-24 {256} (#1657598@0)
oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=c:\somepath\mySpreadsheet.xls;" & _
"DefaultDir=c:\somepath"

check http://www.able-consulting.com/ADO_Conn.htm for details
http://www.able-consulting.com/ADO_Conn.htm
选择excel中你需要的数据，第一行应该是属姓名，后面是值，然后insert-->name-->define-->输入一个名字，这个名字就是select * from 中的table的名字。 -haihai(雪舞); 2004-3-24 (#1657618@0)
Why ADO?!, To use the Excel object is very simple and straight. (1) Declare a veriable (2) Set a value, Done. -debater(say something); 2004-3-27 (#1661218@0)

@Calgary

You must have correct connection string. such as..

Replies, comments and Discussions:

More Topics