import numbers as pure text

[Martin Lord]

I need to import a 5,000 plus record file containing part
numbers. The catch is the part numbers can be pure text,
pure numbers or a combination. Obviously I need to import
it to a text field which I do succesfully except that the
ones that are pure number like: 1113276 are converted to:
1.11328e+006 which I can't really use in my queries
because this doesn't match with the other files in my
database. How can I force Acces to import it as pure text.
I tried the import wizard but it doesn't seem to have too
many options.

Thanks!!

ML

 

[DevalilaJohn]

You haven't given some key information, like what is the source of your data.
What is the data type shown on the table created by the import?

Assuming that it is Excel or something similar, I'd suggest that you go back
to the import wizard and find a row that has a straight number in it. Click

 

[Rosco]

I need to import a 5,000 plus record file containing part
numbers. The catch is the part numbers can be pure text,
pure numbers or a combination. Obviously I need to import
it to a text field which I do succesfully except that the
ones that are pure number like: 1113276 are converted to:
1.11328e+006 which I can't really use in my queries
because this doesn't match with the other files in my
database. How can I force Acces to import it as pure text.
I tried the import wizard but it doesn't seem to have too
many options.

Thanks!!

ML

Well, your not saying what kind of file you are trying to import. Assuming
it is an Excel file, open it and resave as a ".csv" file. A csv format is
nothing more than a delimited text file. When you use the import wizzard you
will see the options under the advanced button, to select data type. In my
infromal testing, it correctly identified all as text and imported correctly.

Hope this helps
Rosco

 

[John Vinson]

I need to import a 5,000 plus record file containing part
numbers. The catch is the part numbers can be pure text,
pure numbers or a combination. Obviously I need to import
it to a text field which I do succesfully except that the
ones that are pure number like: 1113276 are converted to:
1.11328e+006 which I can't really use in my queries
because this doesn't match with the other files in my
database. How can I force Acces to import it as pure text.
I tried the import wizard but it doesn't seem to have too
many options.

Thanks!!

ML

Just to add to Rosco's and John's suggestions, you may want to create
the table *first*, with the desired field types; then link to the
external data (rather than importing it) and base an Append query on
the linked table.

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