请问：前端是EXCEL，后端是ACCESS，请问如何相连。

[llovedb]

菜鸟请问各位高手：excel表中的单元格能和ACCESS中的记录直接相连吗？如何相连？

[changechange]

数据 -> 导入外部数据 -> 导入数据

如果多次使用可以用

数据 -> 导入外部数据 -> 新建数据库查询

[HawaiiLeo]

Dim strCnn As String
Dim strSql As String
Dim k As Integer
k = 0

strCnn = "Provider=sqloledb;" & _
"Data Source=data_server1;Initial Catalog=soap;User Id=sa;Password=; "
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open strCnn
strSql = "select * from youTable where ...."
rs.open strSql,conn,1,1

Sheets(1).Select
do while not rs.eof
Range("F" & k) = rs(1)
k = k + 1
rs.MoveNext
loop

rs.close
conn.close
set rs = nothing
set conn = nothing

[joyqiaoyi]

也可以用vc写一个xll加载宏，通过加载宏里支持的特定函数与数据库相连，创建xll请参见
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q178/4/74.asp&NoWebContent=1