I am brand new to programming I'm trying to finish my last programing assignment for the semester and have hit a wall. I'm suppose to create a database that list a countries name, that countries currency type, and the conversion rate from 1 USD to a selected currency type.

I'm using VB 2010
the connection method I'm using is Microsoft Access Database File (OLE DB)

here is my code i have high lighted the part of code in red that is giving me the problem and entered my question in green text at the point i keep getting the error.

Private Sub btnConvert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnConvert.Click
'access and stores the database
Dim strSql As String = "Select * FROM Currency"
Dim strPath As String = "Provider=Microsoft.Ace.OLEDB.12.0 ;" _
& "Data Source=C:\Users\Per\Documents\Currency.accdb"
Dim odaCurrency As New OleDb.OleDbDataAdapter(strSql, strPath)
Dim datCurrency As New DataTable

odaCurrency.Fill(datCurrency) This is where i keep getting a error. This is the error i keep getting:
System.Data.OleDb.OleDbException was unhandled
ErrorCode=-2147217900
Message=Syntax error in FROM clause.
Source=Microsoft Office Access Database Engine

odaCurrency.Dispose()


Dim intcount As Integer
Dim strCurrencyType As String = Currency_NameComboBox.Text
Dim decUSDollars As Decimal = Convert.ToDecimal(txtUSDollars.Text)
Dim decConverted As Decimal
Dim decMulitlplyer As Decimal

For intcount = 0 To datCurrency.Rows.Count - 1
If strCurrencyType = Convert.ToString(datCurrency.Rows(intcount)("Currency Name")) Then
decMulitlplyer = Convert.ToDecimal(datCurrency.Rows(intcount)("Amount"))
decConverted = decUSDollars * decMulitlplyer
Me.lblDollars.Text = decUSDollars.ToString("C") & (" is equal to")
Me.lblConverted.Text = decMulitlplyer.ToString("F") & strCurrencyType
End If
Next

End Sub