How to import text file with percent greater than 100%

L

Landy101

Trying to import a txt file (comma delimited) a field that has a value
greater than 100% imports to Access with five digits to the right of the
decimal point. I have tried many combinations and cannot get the right value
in Access. A search has revealed nothing.
Thanks, Andy Johnson
 
J

John Vinson

Trying to import a txt file (comma delimited) a field that has a value
greater than 100% imports to Access with five digits to the right of the
decimal point. I have tried many combinations and cannot get the right value
in Access. A search has revealed nothing.
Thanks, Andy Johnson
Click to expand...

What's the datatype of the field into which you are trying to import?
What "combinations" have you tried - what steps are you taking to do
the import?

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing data 0
Format a Percent 4
Importing Tab Delimited Text File to an Existing Table in Access 3
CSV Data/Import Issues 1
Importing File greater than 65536 8
how to check if a number has no more than 2 decimal digits 12
Access 2003: Import Extensionless Files 3
Importing taxt extract file with Numbers and decimals 4

Top