Problem with Microsoft.ACE.OLEDB.12.0 when source file has more than 32k rows

Hi,

I'm using vba code in Access 2007 to read excel files to feed Access tables:

Set cn = New ADODB.Connection
With cn
    .Provider = "Microsoft.ACE.OLEDB.12.0"
    .ConnectionString = "Data Source=" & source & ";Extended Properties=Excel 8.0;"
    .Open
End With
Set rsEX = New ADODB.Recordset
rsEX.Open ("SELECT * FROM [TMP_PARExport]"), cn
While Not rsEX.EOF
    'some code here
    rsEX.MoveNext
Wend

This code works great, I can then use recordsets to read the data and navigate through the records, etc

My problem:
if the excel files has more than 32k rows (precise number of rows TBD), it doesn't work anymore, I have to manually stop the code with windows task manager.
Note: the data in each excel file is exactly of the same type and same format, just the number or rows is different.

I couldn't find anywhere a solution to this problem, any help will be much appreciated.
I have windows xp pro 2002 with sp3.

Tags: ADO, VBA, Microsoft Access