Sort problem when importing

[Binary Dave]

Looking for some help. Not really sure if this is VBA or Access. I'm
using Access97, and using the TransferText command, and I want the
text file to come into the Access table as is; no sorting. However,
when I open the table, the records aren't in the same order as the
import file. Any suggestions? Here's my syntax: DoCmd.TransferText
acImportFixed, mySpec, _
tableName, myString

Thanks in advance!

Dave

[Jeff North]

On 18 Jul 2003 07:32:34 -0700, in comp.lang.visual.basic
by*****@ivillage.com (Binary Dave) wrote:

| Looking for some help. Not really sure if this is VBA or Access. I'm
| using Access97, and using the TransferText command, and I want the
| text file to come into the Access table as is; no sorting. However,
| when I open the table, the records aren't in the same order as the
| import file. Any suggestions? Here's my syntax: DoCmd.TransferText
| acImportFixed, mySpec, _
| tableName, myString

Do you specify a primary key on any of your fields when importing
(mySpec)? Access will automatically sort of these fields.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[aponroy]

Looking for some help. Not really sure if this is VBA or Access. I'm
using Access97, and using the TransferText command, and I want the
text file to come into the Access table as is; no sorting. However,
when I open the table, the records aren't in the same order as the
import file. Any suggestions? Here's my syntax: DoCmd.TransferText
acImportFixed, mySpec, _
tableName, myString

Thanks in advance!

Dave

Beware of fields names. If any of the fields name you have defined begins by "num", Access will put automatically an "index" on it. Is it your case ?
Alain