Hello,
currently each time I import a excel file with data into a table, approximately 65K rows(containing no data) are added to the table. How can I fix this? I will appreciate your help very much.
I am using the following statement to import the excel file into the table into the
SPECTRUM_CALCULATION table
DoCmd.TransferSpreadsheet acImport, nSpreadSheetType, "SPECTRUM_CALCULATION", _
cFileName, Me!ChkBox_FieldNames
Santosh
currently each time I import a excel file with data into a table, approximately 65K rows(containing no data) are added to the table. How can I fix this? I will appreciate your help very much.
I am using the following statement to import the excel file into the table into the
SPECTRUM_CALCULATION table
DoCmd.TransferSpreadsheet acImport, nSpreadSheetType, "SPECTRUM_CALCULATION", _
cFileName, Me!ChkBox_FieldNames
Santosh