Hi I am trying to display a few records from MS Access but I keep getting an error stating:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot find the input table or query 'MailingList'. Make sure it exists and that its name is spelled correctly.
I have a database called test.mdb with a table called MailingList, which contains the following data:
MailingListID FirstName LastName WorkPhone EmailAddress
1 Homer Simpson 212K345835 email@example.com
2 Carl Carlson 212K352981 firstname.lastname@example.org
3 Lenny Leonard 212K363284 email@example.com
What I want my query to do is display the first name and last name in the MailingList table. The query I am using is:
string strSQL = "SELECT MailingList.FirstName, MailingList.LastName FROM MailingList";
Which should display the first and last names, when I do that it generates the error I mentioned above. Any idea whats wrong with it I have been working on this for two days and just need some fresh eyes to take a look at it. Any help is greatly appreciated.