transferSpreadSheet problem importing excel to access

[Quique]

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.

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
here, 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.