If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing Spreadsheets dropping five rows
Hi,
I have a most perplexing problem. When I Import a spreadsheet I am getting all but 5 rows. If I add a column of psuedo row number for debugging, all the records come in. Plain old code. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblST_Americas", Forms!frmTab!frmLoad!txtLoaded3, True What's up with this??? Kevin |
#2
|
|||
|
|||
Importing Spreadsheets dropping five rows
Kevin -
Could there be a table or field constraint that could be preventing in import (e.g. duplicate key values that adding an rownum column fixes)? Is there anything different about the records being skipped? Is it always the last 5 records or always the same records? What happens if you sort the spreadsheet differently before the import - does it change which records are missed? These questions may help determine if it is a data issue or not. Maybe a few records have a text string that looks like a number? How many total records are being imported? Give us a little more information and we might be able to help a little more... -- Daryl S "kc-mass" wrote: Hi, I have a most perplexing problem. When I Import a spreadsheet I am getting all but 5 rows. If I add a column of psuedo row number for debugging, all the records come in. Plain old code. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblST_Americas", Forms!frmTab!frmLoad!txtLoaded3, True What's up with this??? Kevin . |
Thread Tools | |
Display Modes | |
|
|