Two tables with the same data structure as the table view:
The code copy is as follows:
Special
SpecialidNClassnamepic
1Dance of the sun at dawn
2 Jacky Cheung
3 Edison Chen's album of the same name
4 Aaron Kwok listens to the wind's song
view
SpecialidNClassnamepic
1Dawn fire dance sunshine photo/200606192321.jpg
2 Jacky Cheung's long and long photo/200606192327.jpg
3 If Andy Lau one day photo/200606192328.jpg
4Aaron Kwok's songs by listening to the wind photo/200606192329.jpg
To copy the PIC data in VIEW into Special in batches (the singer's name must be exactly the same as the album), the code is as follows:
Copy the code as follows: <%
dimconn
dimconnstr
'onerrorresumenext
connstr="DBQ="+server.mappath("p#1.mdb")+";DefaultDir=;DRIVER={Microsoft AccessDriver(*.mdb)};"
setconn=server.createobject("ADODB.CONNECTION")
OnErrorResumeNext
conn.openconnstr
%>
<html>
<head>
<title>Management Software</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
</head>
<bodybgcolor="#FFFFFF"text="#000000">