Undesirable Importing to Scienitific Notation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,

Any suggestion or tips would be greatly appricated. My setup is importing 8
tab delimited text files programtically. I have defined the Import specs and
they correctly referenced in VBA. When I import the files manually the first
coloumn which is a 16 digit numberimports correctly. However when I use the
same import spec programatically it turns it into Scientific Notation. This
number is the Primary Key from the program which sends this text file, but it
is sequencial so I lose all ability to discern one record from another when
this goes to Scientific notation. The records sets from these are about 1.3
million records.

Any thoughts? I have tried about everything I can think of
 
Are you importing into Access? As far as I know, scientific notation is a
display format, not a data storage format. Are you trying to see the values
directly in a table? Have you expanded the width of that column?

Regards

Jeff Boyce
<Office/Access MVP>
 
What field type are you importing these numbers to?

It can't be a Long because they don't hold 16 digits. It mustn't be a
Double or Single, because they don't have 16 digits worth of precision.

If you don't need to do arithmetic with these primary key values, import
them to a text field.
 
Yes, after importing into Access, the data is in Scientific Notation. I
have tried to expand the width of the coloumn. I have also tried
unsucessfully to perform SQL joins.

It is company software Version 9.0 SP-3
 
Back
Top