Importing Data from Access to Excel

[Mat1024]

Hi everyone,

I have a strange problem: when I import data from access to excel, sometimes, the order of the fields get mixed up

Example of normal order:
1
2
3
4
5

Example of mixed up order:
5
3
4
1
2

I don't know what is the matter, as it only happens sometimes. Can you help me?

(the database is on a shared computer and the other computers import the data from it)

 

[Ron_dK]

Assuming that you import from an Acess query, make sure that the field
with the 1, 2, .... number is sorted ascending. If not make the sort :ascending part of the querydef.

 

[neileg]

Do you mean that the fields are mixed up or that the records are mixed up? If it's the fields, thats worrying. If it's the records, then there is no order to records in a table, unless you impose one. A Table is an unordered recordset.

 

[Mat1024]

Assuming that you import from an Acess query, make sure that the field
with the 1, 2, .... number is sorted ascending. If not make the sort :ascending part of the querydef.

I use the "Import External Data" Function of Excel, and then import the whole database.

 

[Mat1024]

Do you mean that the fields are mixed up or that the records are mixed up? If it's the fields, thats worrying. If it's the records, then there is no order to records in a table, unless you impose one. A Table is an unordered recordset.

You are right, it is not the fields but the records. The strange thing is that only the beginning of the records (10 records) are mixed up. The following records are perfectly sorted...

 

[Ron_dK]

I use the "Import External Data" Function of Excel, and then import the whole database.

I would suggest to use the export function in Access rather than the import function in Excel.

Nevertheless, when using the import function in excel, you can only import tables and/or queries.
As I said before, if you sort the tables and the queries on the field that you require the data to be in line in excel, the import should be succesfull.