I tried with this code, but it gives me nothing from GetTables()
Code: Select all
wxFileDialog fdlog(this, "Open a file","","","*.xls");
if(fdlog.ShowModal() != wxID_OK) return;
filename.Clear();
filename = fdlog.GetPath();
wxString s = wxT("DRIVER={Microsoft Excel Driver (*.xls)};DSN='';DBQ=") + filename;
OdbcDatabaseLayer* m_pDatabaseLayer = new OdbcDatabaseLayer();
if(m_pDatabaseLayer->Open(s))
m_textCtrl1->AppendText(s);
wxArrayString table_names;
table_names = m_pDatabaseLayer->GetTables();
Code: Select all
table_names = m_pDatabaseLayer->GetColumns("Dist$");