can't import number into text field

  • Thread starter Thread starter Martin Lord
  • Start date Start date
M

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.
 
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? . . .
Click to expand...

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
 
Back
Top