Originally Posted by
mpearce
Data within the cells in excel is small probably under 50 characters so a text data type should be fine, right? anyway for testing i changed the data type to memo and that seemed to work. but somehow blank rows get inserted as either the first or last record which was throwing an error due to a primary key constraint violation.
basically i need a primary key so i can relate the tables on account number so i can run the join query and find the duplicate account numbers in DecoOpen and DecoOpen (2) for example and then put the results of that query into a report.