Hello,
Sometimes when i import an excel spreadsheet into a table in my database it gives me an error about how not all the data was input correctly.
I go and find out which record wasnt input correctly, go back to excel, delete all the other records int eh sheet apart from the one that didnt go in and retype it exactly as it was before and it goes in fine (note that just getting rid of the others and trying doesnt work, it needs to be retyped).
Could someone tell me why this happens? The records dont use any special characters or anything, are all of varying length (majority of the time there will be inputs bigger than the one that gets rejected) and its hgely annoying to have to retype somethign again.
Sometimes when i import an excel spreadsheet into a table in my database it gives me an error about how not all the data was input correctly.
I go and find out which record wasnt input correctly, go back to excel, delete all the other records int eh sheet apart from the one that didnt go in and retype it exactly as it was before and it goes in fine (note that just getting rid of the others and trying doesnt work, it needs to be retyped).
Could someone tell me why this happens? The records dont use any special characters or anything, are all of varying length (majority of the time there will be inputs bigger than the one that gets rejected) and its hgely annoying to have to retype somethign again.