I have a problem importing a table to oracle. When I import it a field is import for example:  

In access I have '20,200' and import to oracle '20' or ‘125.35’ in access and import to oracle as '12535'

In access it is declared as number, and in oracle it is already changed to text, float...

//----------------------------------------------------------------------------------- EDIT -----------

Is only a field that is giving problems. Yhe field in access is declared as number, and when I import the table to access it convert the field to binary\_char

And import OK, but then I change that type to float or text, or other, and when I import info to that table, it import the fields like this examples:

In access: '20,200' -> to oracle '20'

In access: '125.35' -> to oracle '12535'

This is the code I used:

```
Option Compare Database

Function load_tables()

    Dim resposta

    varReturn = SysCmd(acSysCmdInitMeter, " ", 36)
    varReturn = SysCmd(acSysCmdSetStatus, " ")

    DoCmd.SetWarnings False

    varReturn = SysCmd(acSysCmdSetStatus, "Insert In Emb")
    DoCmd.RunSQL "INSERT INTO INFAR_Emb( Emb_ID, N_Registo, Descr, Compart, " & _
                                    "Data_Compart, Grupo_Hom_ID, Me_ID, " & _
                                    "Data_Alter, Data_Alt_Comp) " & _
                "SELECT [Emb_ID], [N_Reg], [Descr], [Compart], " & _
                                    "[Data_Compart], [Grupo_Hom_ID], " & _
                                    "[Me_ID], [Data_Alter], [Data_Alt_Comp] " & _
                                    "FROM [Emb] where [Emb_ID]=257"

```