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.
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.
