Import Error

  • Thread starter Thread starter Supe
  • Start date Start date
S

Supe

I am trying to import some 10 digits UPCs into a table but it only imports
the UPCs that start with 1. Any UPC that starts with anything other than 1
is left blank in the table. The descriptions all import, but not the UPCs
that start with anything other than 1???????
 
Supe,
It always helps the volunteers who answer questions here if you include as
much information as possible about the problems.
What file type are you importing from?
Try importing the UPCs into a table with field type text.
If successful, use a query to format the data as you need and import it into
the real field in your acess table.

Jeanette Cunningham
 
Supe,
It always helps the volunteers who answer questions here if you include as
much information as possible about the problems.
What file type are you importing from?
Try importing the UPCs into a table with field type text.
If successful, use a query to format the data as you need and import it into
the real field in your acess table.

Jeanette Cunningham





I am trying to import some 10 digits UPCs into a table but it only imports
the UPCs that start with 1.  Any UPC that starts with anything other than1
is left blank in the table.  The descriptions all import, but not the UPCs
that start with anything other than 1???????
Click to expand...


In addition to Jeanette's comments, can you import it into Excel?
Sometimes trying another tool will give you some clues.

Hope this helps,
Chris M.
 
Back
Top