strConn--〉ADODB.Connection对象,file_path-->String。
我的设置:
strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = E:\table\work.xls; Extended Properties = ""Excel 8.0;HDR=Yes;IMEX=1"""
没问题,如果这样:
file_path = "E:\table\work.xls"
strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = file_path; Extended Properties = ""Excel 8.0;HDR=Yes;IMEX=1"""就不行了,说:"E:\table\file_path.xls"不存在”,就是说它把file_path当成字符串了。但是我的数据文件路径是根据输入来连接的。strConn该怎么写?
我的设置:
strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = E:\table\work.xls; Extended Properties = ""Excel 8.0;HDR=Yes;IMEX=1"""
没问题,如果这样:
file_path = "E:\table\work.xls"
strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = file_path; Extended Properties = ""Excel 8.0;HDR=Yes;IMEX=1"""就不行了,说:"E:\table\file_path.xls"不存在”,就是说它把file_path当成字符串了。但是我的数据文件路径是根据输入来连接的。strConn该怎么写?
不用& 你的data source就是file_path了,而file_path是个变量