T
Tom
I have a Text (Tab) Delimited file (saved from Excel) that gives me problems
with data types = "number" in the Access table.
The text file contains values representing "currency" as well as "decimals".
For instance, their values are "$1,250.00" and "0.1".
When I import the text file, all text gets imported properly. However, the
numbers don't make it (records contain the default value of "0").
I have changed the field size to "long integer", "double", "single",
"decimal". I also modified the format to "General", "Standard", "Currency"
& adjusted the decimal places = 1 or 2.
What am I doing wrong? I can't imagine the text file couldn't contains
e.g. "0.1".
Any suggestions?
with data types = "number" in the Access table.
The text file contains values representing "currency" as well as "decimals".
For instance, their values are "$1,250.00" and "0.1".
When I import the text file, all text gets imported properly. However, the
numbers don't make it (records contain the default value of "0").
I have changed the field size to "long integer", "double", "single",
"decimal". I also modified the format to "General", "Standard", "Currency"
& adjusted the decimal places = 1 or 2.
What am I doing wrong? I can't imagine the text file couldn't contains
e.g. "0.1".
Any suggestions?