retrieve to ?
.. sql, oracle, c++, vb6, perl, excel, word, ...
MS has plenty of articles on how to manipulate tables and fields in msaccess, but you'd need to use one of their component libraries.
For instance, in Excel, reference to "Microsoft DAO 3.6 Object Library"
Public Sub GetTablesAndFields()
On Error GoTo err_GetTablesAndFields
Dim db As DAO.Database
Dim tbl As DAO.TableDef
Dim fld As DAO.Field
Set db = DBEngine.OpenDatabase("...\xxx.mdb")
For Each tbl In db.TableDefs
Debug.Print tbl.Name
For Each fld In tbl.Fields
Debug.Print "... " & fld.Name
Next fld
Next tbl
sub_exit:
If (Not db Is Nothing) Then
db.Close
End If
Exit Sub
err_GetTablesAndFields:
Debug.Print Err.Description
GoTo sub_exit
End Sub
Joe
Enter your message below
Sign in or Join us (it's free).