1. Set all rows to MyRange
2. Once this is done click link above.
Delete Bundle Tables and reload with Excel spreadsheet
1. The Jet OLE DB provider (DSN or DSN-less) reads a registry key to determine how many rows are to be read to guess the type of the source column. By default, the value for this key is 8.
So the provider scans the first 8 rows of the source data to determine the data types for the columns.
If any field looks like text and the length of data is more than 255 characters, the column is considered a memo field.
If there is no data with a length greater than 255 characters in the first 8 rows of the source, Jet will consider the column as text with a limit of 255.2. First make the last line in the Excel file read NULL for state
3. Set all rows except the last one to MyRange
4. Once this is done click link above.
5. Add special CA split ethics exams to bundles manually.
1. Click on "Create Ticklers for Proctored and Non-Proctored Exams" link above.