I have created a connection in EXCEL 2007 to an Access Database. the data in
question has a column which is always in nuimberical order as 1 above 2 above
3, etc.

Most data imports correctly but randomly the order reverses 2 before 1.

When I look at the Access database table all is correctly ordered.

Any ideas?

In an Access table there is no inherent order. It is only during display that
Access orders the data as per the settings in effect at that time or based on
primary key.

You may try creating a view where you specify the order and then import from
there (just guessing, have not worked in Access for years).

"bonsaimarles" wrote:

I have created a connection in EXCEL 2007 to an Access Database. the data in
question has a column which is always in nuimberical order as 1 above 2 above
3, etc.

Most data imports correctly but randomly the order reverses 2 before 1.

When I look at the Access database table all is correctly ordered.

Any ideas?

Hi,

I think that is not correct. There is an inherent order to the data in a
table, it is the order that the data was entered. If the table has a primary
key then the default display of the data is based on the sort order of the
Key. If you manually enter numbers in a column to provide an order to the
display and then sort the data, the data is displayed order on that field,
however, the underlying order is still based on the order of data entry.

You can always sort it when you bring the data into Excel.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Sheeloo" wrote:

In an Access table there is no inherent order. It is only during display that
Access orders the data as per the settings in effect at that time or based on
primary key.

You may try creating a view where you specify the order and then import from
there (just guessing, have not worked in Access for years).

"bonsaimarles" wrote:

I have created a connection in EXCEL 2007 to an Access Database. the data in
question has a column which is always in nuimberical order as 1 above 2 above
3, etc.

Most data imports correctly but randomly the order reverses 2 before 1.

When I look at the Access database table all is correctly ordered.

Any ideas?

Well, I will have to go back and verify this....

but when I used to work with Access -
what you said was true if you did not delete any records, if you enter
enough records, delete a few and add a few, there was no guarantee that you
would get the same order as you entered while displaying specially if the
database had other objects and you compacted it.

"Shane Devenshire" wrote:

Hi,

I think that is not correct. There is an inherent order to the data in a
table, it is the order that the data was entered. If the table has a primary
key then the default display of the data is based on the sort order of the
Key. If you manually enter numbers in a column to provide an order to the
display and then sort the data, the data is displayed order on that field,
however, the underlying order is still based on the order of data entry.

You can always sort it when you bring the data into Excel.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Sheeloo" wrote:

In an Access table there is no inherent order. It is only during display that
Access orders the data as per the settings in effect at that time or based on
primary key.

You may try creating a view where you specify the order and then import from
there (just guessing, have not worked in Access for years).

"bonsaimarles" wrote:

I have created a connection in EXCEL 2007 to an Access Database. the data in
question has a column which is always in nuimberical order as 1 above 2 above
3, etc.

Most data imports correctly but randomly the order reverses 2 before 1.

When I look at the Access database table all is correctly ordered.

Any ideas?