J
John Melbourne
I'm trying to import a text file with numeric data in to a table, when I run
the import it brings all numbers in as positive. I have described the field
as Double and it is 8 long with 2 decimals. The data to import looks like
'0000.00-' '1530.21' imports ok but '108.35-' comes in as '108.35'
I have no control over the data give, should I reformat the data to place
the sign at the front of the field?
Thanking you in advance.
the import it brings all numbers in as positive. I have described the field
as Double and it is 8 long with 2 decimals. The data to import looks like
'0000.00-' '1530.21' imports ok but '108.35-' comes in as '108.35'
I have no control over the data give, should I reformat the data to place
the sign at the front of the field?
Thanking you in advance.