While importing the essbase retrieved data from excel spreadsheet to access database using the folling Access VBA command, I get 65 K of blank rows into the table. This only happens for essbase retrieved data, other excel files works just fine. Is there a reason, and how can I prevent this 65 K blank rows? Please help. Thank you much.

VBA command to import excel data

DoCmd.TransferSpreadsheet acImport, nSpreadSheetType, "SPECTRUM_CALCULATION", _
cFileName, Me!ChkBox_FieldNames