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.TransferT ext
acImportFixed, mySpec, _
tableName, myString

Thanks in advance!

Dave

[Jeff North]

Re: Sort problem when importing

On 18 Jul 2003 07:32:34 -0700, in comp.lang.visua l.basic
bytedad@ivillag e.com (Binary Dave) wrote:
[color=blue]
>| 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.TransferT ext
>| acImportFixed, mySpec, _
>| tableName, myString[/color]

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

[aponroy]

Beware of fields name

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.TransferT ext
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