Type Conversion Failure Access 2007 Double

[evertVB]

I want to import a texfile into an Access table.

My textfile contains the following:

somemoredata;+025,1234;somemoredata

The delimitor is set to semicolon.
The decimal symbol is set to comma - both in my regional settings and in the import whizard.
The target field is a Double with Decimal Places set to Auto.

I expect 25,1234 in my database field.
However, the result is an import error: Type Conversion Failure

I recently switched to Acces 2007. With the previous Access version this very same import worked fine.
Could someone confirm the same problem and/or a solution?

I just hope there will be no need to modify existing procedures only because I upgraded my Access.

 

[Guus2005]

are you sure the error points to this particular field?
are you sure the format of the field is the same in every record?

HTH

 

[evertVB]

yes & yes

 

[Guus2005]

is the value required and you are importing empty fields?

Please post a sample database and dito import file.

 

[evertVB]

in a few minutes

 

[evertVB]

The example: