Problems with DoCmd.TransferSpreadsheet function

[irethedo]

I am using a DoCmd.TransferSpreadsheet function to copy a spreadsheet into an Access table which was working fine
(creating a 276 record table from a 276 line spreadsheet), but now it is taking a 276 line spreadsheet and creating a table with 14652 records.

I am told that this is an excel 2007 format and the command that I am using is:

  DoCmd.TransferSpreadsheet acImport, 8, "NewData_tbl", In_File, True

Not sure what changed. How can I correct this?

Thanks

 

[irethedo]

Ok, I changed this to a type 9 for the Excel 2007 format :

    DoCmd.TransferSpreadsheet acImport, 9, "NewData_tbl", In_File, True

And then added the following:

    strSql = "Delete * FROM NewData_tbl"
    CurrentDb.Execute strSql

before the DoCmd.TreansferSpreadsheet function which clears out the data in the table,
and all is well