I'm not sure what you want, but it may be this.
<!--- Form to be submited --->
<form action="nextpage.cfm?total=10" method="post">
<table cellpadding=0 cellspacing=0 border=0>
<cfloop index="index" from="1" to="10">
<tr>
<td>FName</td>
<td><input type="text" name="FName_#index#">
<td>LName</td>
<td><input type="text" name="LName_#index#">
<td>Sex</td>
<td><input type="text" name="Sex_#index#">
<td>Race</td>
<td><input type="text" name="Race_#index#">
<td>Age</td>
<td><input type="text" name="Age_#index#">
</tr>
</cfloop>
</table>
</form>
<!--- INSERT Page For ACCESS level DB --->
<cfloop index="index" from="1" to="#url.total#">
<cfquery datasource="myDB">
INSERT INTO myTable(FName,LName,Sex,Race,Age)
VALUES(
'#EVALUATE("FROM.FName"&index)#',
'#EVALUATE("FROM.LName"&index)#',
'#EVALUATE("FROM.Sex"&index)#',
'#EVALUATE("FROM.Race"&index)#',
#EVALUATE("FROM.Age"&index)#
)
</cfquery>
</cfloop>
<!--- INSERT Page For MSSQL2K level DB --->
<cfquery datasource="myDB">
<cfloop index="index" from="1" to="#url.total#">
INSERT INTO myTable(FName,LName,Sex,Race,Age)
VALUES(
'#EVALUATE("FROM.FName"&index)#',
'#EVALUATE("FROM.LName"&index)#',
'#EVALUATE("FROM.Sex"&index)#',
'#EVALUATE("FROM.Race"&index)#',
#EVALUATE("FROM.Age"&index)#
)
</cfloop>
</cfquery>
The difference between the two DB types
is in MSSQL2K you can send all your info
in one database call making the code
more efficiant.
Hope this is what you are after.