<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type"销桥猜 content="text/htmlcharset=gb2312">
<title>数据下载</title>
</head>
<body>
<p align="center"> </p>亏型
<p align="center"> </p>
<%
'创建一个FileSystemObject对象的事例
Set MyFileObject=Server.CreateObject("Scripting.FileSystemObject")
'创建一个Folder对象
foldername=server.mappath("./1/")
Set MyFolder=MyFileObject.GetFolder(foldername)
'Set MyFolder=MyFileObject.GetFolder("d:\1")
'循环显示其中文件
For Each thing in MyFolder.Files 'MyFolder.subfolders 显示文件夹,MyFolder.Files 显示文件
'response.write "<p>"&thing
response.write ("<p align="&"center"&"><font size="&"5"&">消薯<a href="&"/1/"&thing.name&">"&thing.name&"</a></font></p>")
Next
%>
</body>
</html>
方法一:CsvPath=你的CSV的文件夹
connStr
=
"Driver={Microsoft
Text
Driver
(*.txt
*.csv)}"&_
"Dbq="&
CsvPath
&""&_
"Extensions=csvt"&_
"Persist
Security
Info=False"
set
conn
=
Server.CreateObject("Adodb.Connection")
在这李举里,文件夹做为一脊悄个库,里面的每个CSV文件,将樱扰渣被当做一个表来 *** 作,就跟 *** 作数据库一样,导入也就像两个库互导而已
SELECT
*
FROM
×××.CSV
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)