Search results

Okay, I took what you said to heart and found the problem. Since the workbook has the format we need we had it protected and the user would fill it out. The problem is that we haven't ever had where all the lines were used. So I tested with deleting all the blank formatted lines after the...

It imports everything fine, Just get that "error" for each workbook that imports. And it only imports the lines with information on them, not the empty lines. And it wouldn't make sense to delete all the empty lines because then I have to go into each workbook to delete lines when it is less...

Yes the primary key and no dupe indexes. But that doesn't matter since I tried removing them and still got the error. When I did a test import to a new table, the new table nearly matched the original table. The only differences was in the size of the text fields and the number fields were...

I am having issues with importing into Access from Excel. I am getting the following Error: "Microsoft Access was unable to append all the data to the table The content in 0 record(s) were deleted, and 0 record(s) were lost due to key violations" All the fields in my Excel spreadsheet are in...