import parsing

  • Thread starter nerlbaum via AccessMonster.com
  • Start date
N

nerlbaum via AccessMonster.com

attempting to import fields from a bang delimited text file, some fileds
contain |+/-1,234| as an example. the result of the import is that the field
is parsed as 1,234. what happened to the +/-?
 
J

Jeff Boyce

How is Access defining the field into which it places the value? It may be
that it believe the field contains a number.

"+/-1,234" is not a number, it's a character string that happens to contain
some digit characters.

Are you letting Access determine the destination table/fields, or are you
appending into an existing table with the field types already defined?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
N

nerlbaum via AccessMonster.com

We always import all fields as text and then adjust the table, since we never
know what we may encounter.

Nathan Erlbaum
 
J

Jeff Boyce

That was my best (and only) guess. Perhaps one of the other newsgroup
readers has run across this...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top