To find out the data type of each field in an Access table, you can use DAO or ADOX.
Private Sub TableDefDao()
Dim db As DAO.Database
Set db = DAO.OpenDatabase("C:\Users\Julien\Documents\Database2.mdb")
Dim t As DAO.TableDef
Dim f As DAO.Field
For Each t In db.TableDefs
Debug.Print t.Name
For Each f In t.Fields
Debug.Print vbTab & f.Name & vbTab & f.Type
Next
Next
End Sub
it's in VB you can convert to c# from followinf site-
http://converter.telerik.com/[
^]