| |

VerySource

 Forgot password?
 Register
Search
Author: sweetywendy

Why does excel import data and lose some records?

[Copy link]

1

Threads

23

Posts

18.00

Credits

Newbie

Rank: 1

Credits
18.00

 China

Post time: 2020-4-10 17:45:02
| Show all posts
The meaning of upstairs is what I want to say, so determine what type of number is in the table in excel
Reply

Use magic Report

2

Threads

12

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 Unknown

 Author| Post time: 2020-4-10 18:15:01
| Show all posts
The upstairs makes sense.

"Just add a character to this column before importing."
But when importing, what should I do because there are more data.


"After import, use stuff or replace to remove this character."
I will. oo. . ~ Q ~
Reply

Use magic Report

2

Threads

12

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

 Author| Post time: 2020-4-10 23:45:02
| Show all posts
Now, just want a column in excel, no matter what type it is, import it into sql,
None will be null.
May I?
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list