vangogh228
Registered User.
- Local time
- Today, 13:50
- Joined
- Apr 19, 2002
- Messages
- 302
I have attempted to import an Excel spreadsheet of 409 records into an existing table. I got all my field names done OK, and all the data came in OK... EXCEPT:
In the table, I have six Y/N checkboxes. In the spreadsheet, I had the input clerk put in "Yes" and "No" in the appropriate cells. I got an error that said "There was an error during the import. Import not completed. 409 records were converted to NULL because of data conversion errors."
Once I simply deleted the columns in the spreadsheet that held the "Yes" and "No" data, the conversion completed fine.
Any ideas on how to import "Yes" and "No" data???? Thanks!!!
In the table, I have six Y/N checkboxes. In the spreadsheet, I had the input clerk put in "Yes" and "No" in the appropriate cells. I got an error that said "There was an error during the import. Import not completed. 409 records were converted to NULL because of data conversion errors."
Once I simply deleted the columns in the spreadsheet that held the "Yes" and "No" data, the conversion completed fine.
Any ideas on how to import "Yes" and "No" data???? Thanks!!!