santoshg
06-11-02, 19:04
| Hello- 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 Santosh |