Need help getting .mdb to show in datagridview in visual basic 2015

[MDelke]

I can get some of the tables to show but not all of them. I know mdb is outdated but I am trying to convert a visual basic 6 program without doing a lot of work on the database if possible.



here is the code:

Dim ds as New Dataset
Dim dt as new Datatable
ds.tables.add(dt)
dim da as New oledbDataAdapter

con.ConnectionString = ("my conection String Here")
con.Open()

da = New OleDbDataAdapter("select * from QSO - Master",con)

DataGridView1.DataSource = dt.DefaultView

con.Close()

Any help would be appreciated.
Mike

[June7]

Is QSO - Master the name of a table or query? Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention. Those could be source of issue. Better would be QSO_Master or MasterQSO.

Try wrapping in [].

"select * from [QSO - Master]"


Might find a VB forum if you have questions that are more VB than SQL related.

[MDelke]

Thanks for the help. I agree the naming convention was strange but enclosing in [] did the trick. Thank You again