TransferSpreadSheet import excel to access problem (undesired reordering)

[qq]

Hello,
I've got a problem importing a worksheet Excel into a temporary table
in
access. All the information is imported but the table is not ordered
as
it is originally in excel.

I'm using a VBA code rather simple as the following:

Private Sub Import()
...
Dim TableName As String
DoCmd.TransferSpreadsheet , , TableName, XLFileName, , test!"A10:AX"
....
End Sub

where XLFileName is my excel file and "test" my worksheet within that
file.


This code imported perfectly all the records from the excel file but
since the worksheet increased number of lines up to 1800 (which I do
not
consider is a big number!) all of them are imported but after the line
35 (not always the same) jumps to te line 1400 or so, then comes back
to
the line 36 until 80, then again another jump...
Despite of having all data the different order does not help
afterwards.

Do you have an idea about this strange re-ordering? Any help out
there?

Thanks beforehand
Qq

 

['69 Camaro]

Enrique, please don't multipost. Your question has already been answered in
another newsgroup, so if one of the experts answered your same question in
one of the many places you posted this question, he'd be wasting his time.
For more information on posting questions in the newsgroups, please see the
following Web page:

http://www.mvps.org/access/netiquette.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.