Data moving on Export

[Sander]

I am exporting a table to a text file using a specification. Comma Delimited, no text qualifier. Now, I don't know if this makes a difference but the file is decent size (over 1000 records). The data within each record is exporting fine (about 78 fields) however, I have what is a major problem.

About a third of the way in the exported file are 70 records that have exported 60-70 records too early. Those 70 records are in order themselves but they just somehow jumped the gun(if that makes sense). This is a big problem because this file is going to be uploaded to the mainframe.

Just as an FYI the only VBA I have in my whole database is one pop-up message box. Everything else is run with macros. This one table does not have any primary keys since this is the table the information is oringally imported into and is moved from here. What I want is the information to look like it is in the table.

If anyone has any ideas I would really appreciate it. I'm going nuts and so is my mainframe programmer trying to figure out how we're going to get around this.

Thank you!

 

[DreamGenius]

Sander

I'm guessing there's a real need for the data to be in a specific order so, rather than exporting from the table, can you not export from a query with an Order By clause in it?

I believe, and stand ready to be corrected, that the table shows data in the order in which it was entered. The export may be ordering it by say the first column.

Just hypothesising and suggesting a possible solution - I don't know the answer.

 

[neileg]

I would add that, although you think you are looking at the table in Access table view, it's really a query. Since the intrinsic position of a record is irrelevant in a relational database, there's no internal rule that guarantees the order remaining constant. If the order is important, you have to impose that order, you can't assume it.