I am having a problem when transfering an excel file to my database... For some reason when I transfer the file the bottom few records end up on the top of the list when it get into a table... 90% of the time it's the bottom 5 that end up on top...
Here is the code I am using currently:
DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9, "tblSequSched", "\\bb-srv01\PalletMarker$\Schedule\" & strName & ".xls", True
Is there a different way to pull an excel file in, or is my code wrong????
Thanks for the help,
Gurn
Here is the code I am using currently:
DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9, "tblSequSched", "\\bb-srv01\PalletMarker$\Schedule\" & strName & ".xls", True
Is there a different way to pull an excel file in, or is my code wrong????
Thanks for the help,
Gurn