Importing spreadsheets

[horsecow]

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.

 

[llkhoutx]

A common problem in importing excel spreadsheet is with data being formatted in a consistent way, e.g. numeric data really being text.

I'm not certain, but I don't think that you can import cells containing formulas. It has to be converted to numeric or text, as the case may be.