Function RecordsetToTable(rs) 'As String
Dim strTable
Dim intField 'As Integer
Dim strBrowserType 'As String
If Not(rs.EOF And rs.BOF) Then
rs.MoveLast
rs.MoveFirst
'First send out the column headers
strTable = "
" & vbCrLf & ""
For intField = 0 to rs.Fields.Count - 1
strTable = strTable & "" & rs.Fields(intField).Name & " | "
Next
strTable = strTable & "
" & vbCrLf
'Now send out the table body
Do until rs.EOF
strTable = strTable & ""
For intField = 0 to rs.Fields.Count - 1
strTable = strTable & "" & rs.Fields(intField).Value & " | "
Next
strTable = strTable & "
" & vbCrLf
rs.MoveNext
Loop
strTable = strTable & "
"
RecordsetToTable = strTable
Else
RecordsetToTable = ""
End If
End Function