Why does excel import data and lose some records?

sweetywendy · Post time: 2020-2-12 09:00:02

Permit number,
The text type in excel will not be lost, and the data type will be lost.

cv4bf5d65fd · Post time: 2020-4-8 23:15:01

To set to data type, the character type is automatically lost and becomes null

sweetywendy · Post time: 2020-4-9 02:30:01

Is there any good solution?

sweetywendy · Post time: 2020-4-9 09:00:02

Yes. The customer did not pay attention when entering data in excel.
The data in one column turned out to be two types.

How to solve?

kittast · Post time: 2020-4-9 12:45:01

Wouldn't it be good to make this column text?

sweetywendy · Post time: 2020-4-9 21:15:01

I tried text, no way.

gaoqingfeng · Post time: 2020-4-9 22:45:02

The digital type in the landlord's excel, what type is in the table?

gaoqingfeng · Post time: 2020-4-10 00:00:02

Is it a string type?

sweetywendy · Post time: 2020-4-10 13:15:01

In my table, varchar
However, after importing the digital type in excel,
I changed to text type, and it didn't work.

恶魔右指 · Post time: 2020-4-10 14:45:01

No good column specified
Another case: if the column is number + letter, it will be displayed as null after import
Just add a character to this column before importing.
After import, use stuff or replace to remove this character.

		Remember me	Forgot password?
Password			Register