[OLE DB] system.data.oledb.oledbexception : 'syntax error in from clause.'

See more:

C#

OleDb

Hi,

I have this error text "System.Data.OleDb.OleDbException : 'Syntax error in FROM clause.'"
i didn't know why that's doing this error message

Please Can you help me ?

Code :

private void Form1_Load(object sender, EventArgs e)
        {
           
            using (OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\DataBase\Test.accdb"))
            {
                OleDbCommand command = new OleDbCommand("SELECT * FROM note", con);

                con.Open();
                OleDbDataReader reader = command.ExecuteReader();
                listBox1.Items.Clear();
                while (reader.Read())
                {
                    listBox1.Items.Add(reader[0].ToString());
                }
                reader.Close();
            }

        }

Im just trying to get my Databass Note and to print on listbox

What I have tried:

I have another project with other Databass (more important) and the code didn't have an error what i need to do for my other project please help me.

<pre lang="c#"> using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=testapp.accdb"))
            {
                OleDbCommand command = new OleDbCommand("SELECT * FROM T_article",con);

                con.Open();
                OleDbDataReader reader = command.ExecuteReader();
                lbxTableau.Items.Clear();
                while (reader.Read())
                {
                    lbxTableau.Items.Add(reader[0].ToString());
                }
                reader.Close();
            }

i really need to read my databass for my programme :(