I'm having some trouble using TransferSpreadsheet to import Excel data rows. Here's my line:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "T", str, True, "Template!"
I'm using 2010 and the users put their data in an Excel xlm template. The data goes into new table called "T".
I have one of them that I'm looking at now and it has 52 rows of data but only 9 are getting put into the table.
My code opens the File Dialog box for the user to select the template and the program takes it from there.
Can anyone help with this? Thanks very much.