can't import number into text field

[Martin Lord]

I'm trying to import a 5,000 plus record file into
access. The first field is the part number which can be
pure text, pure numbers or a combination of text and
number. So I'm improting it to a text field. The problem
is that those which are pure number are exported like
this. Part number: "1113276" is imported to access
as: "1.11328e+006".

So I'm having trouble with my queries since the other
files in the database have the original "1113276" value.

How can I force Access to import it as all text? . . .

Thanks!!

M.L.

 

[John Vinson]

I'm trying to import a 5,000 plus record file into
access. The first field is the part number which can be
pure text, pure numbers or a combination of text and
number. So I'm improting it to a text field. The problem
is that those which are pure number are exported like
this. Part number: "1113276" is imported to access
as: "1.11328e+006".

So I'm having trouble with my queries since the other
files in the database have the original "1113276" value.

How can I force Access to import it as all text? . . .

What medium contains the external file? Text, Excel spreadsheet,
another database...?

If it's Text, you should use the Advanced option button on the File
Import wizard to specify that the field is of Text type (and of course
import it into a Text rather than a numeric field).

If it's in Excel, export it to a .csv (comma separated values) text
field and proceed as above.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps