如果ACCESS数据表在局域网user01号机(IP地址为192.168.1.101)的D:\中量管理目录下,而user02、user03、user04三台电脑(IP地址分别为192.168.1.102,192.168.1.103,192.168.1.104)的E:\中量管理目录下均有同样格式的EXCEL工作表,那么一楼以下代码的导入导出路径应该如何写呢? Sub ExportToExcel()'导出EXCEL conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\DBBASE.MDB;" & _ "Jet OLEDB:Engine Type=4"
Sub ImportToAccess()'导入原ACCESS conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\DBBASE.MDB;" & _ "Jet OLEDB:Engine Type=4"
[此贴子已经被作者于2007-5-8 10:54:27编辑过] |