Question Import Errors

[chrisguk]

Not importing from Excel properly

Hi there,

I am trying to import some data into one of my tables and I have the following issues:

The PK field namely SitesID is a number (long interger) type.

On the spreadsheet im importing the number is typically 6-7 digits long.

When I import they default to:

1
2
3
4
5
6 and so on

Remembering this is not an autonumber field I cant figure out whats going wrong.

Any ideas?

Chris

 

[GinaWhipp]

Hmmm, well that's not normal. I would confirm the Data Type of the field in the table. I would also tyr creating a second tasble turning that key to TEXT and see if you get the entire number. And another thought, if you are using an Import Specification try recreating it.

 

[boblarson]

When you say they are 6-7 digits long, what are some typical values that are being changed? As Gina had said, if they are leading zeroes then you have to use a TEXT field to store those as number datatypes do not store leading zeroes.