londonkiwi
Programmer
I am developing a programme that will export a txt file to a specified Access DB Table (VB 5)
I have a combo box cboTables, which grabs all the Tables in the selected Database.
The code for this is below. Once the appropriate table (to put the parsed txt data in) is selected, I want to get that table path and name eg c:/mystuff/newdb.mdb/TheTable
I want to a) write to this table b) put the path in a listbox, so the user can see which one they've chosen.
....
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase(gf_strDbpath)
cboTables.Clear
For i% = 0 To db.TableDefs.Count - 1
strTblName = dbTableDefs(i%).Name
cboTables.AddItem strTblName
Next i%
....
Thanks in advance
I have a combo box cboTables, which grabs all the Tables in the selected Database.
The code for this is below. Once the appropriate table (to put the parsed txt data in) is selected, I want to get that table path and name eg c:/mystuff/newdb.mdb/TheTable
I want to a) write to this table b) put the path in a listbox, so the user can see which one they've chosen.
....
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase(gf_strDbpath)
cboTables.Clear
For i% = 0 To db.TableDefs.Count - 1
strTblName = dbTableDefs(i%).Name
cboTables.AddItem strTblName
Next i%
....
Thanks in advance