I am working on a program that will convert access databases .I need to get
each table, field, and field type, but I can't seem to get a list of he
table names.
I have tried this code, but haven't gotten anything.
Function GetTables(ByVal conn As OleDbConnection) As DataTableconn.Open()
Dim schemaTable As DataTable =
conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _
New Object() {Nothing, Nothing, Nothing, "TABLE"})
conn.Close()
Return schemaTable
End Function