In my Excel macro, I am trying to import a spreadsheet into Access. I create
an Access object and am trying to use the "transfer spreadsheet" command. It
works but it is only importing the first line in the spreadsheet.

Below is the code I'm using:

AppAcc.DoCmd.TransferSpreadsheet acImport, 8, "Interest_Table",
"\\vs300\cost_center\ABC\UploadFile.xls", True

Any ideas or suggestions are greatly appreciated. Thanks for the help......
--
JT