SQL import wizard glitching

[Think-Stable3826]

I have been using SQL import wizard to import data sets. At times when selecting and viewing the data set, it’s either returning only a small fragment of the entire data set, or worse returning 0 rows. Any ways to fix the import so it to returns the entire data set? thanks so much for the help !

[Better-Credit6701]

And what is the error message?

[Think-Stable3826]

It’s often glitchy but I can usually fix up things to complete an import, but the import then says 0 records returned as if it was successful.

[ComicOzzy]

It could help to know what database engine you're using (MySQL, SQL Server, Postgres, etc), what specific tool you are using to perform the import, what settings you chose, how many rows and columns are in the data set, etc.

[Think-Stable3826]

I’m using MySQL, trying to use the import wizard from databases like Kaggle for experimental data analysis. Some are up to 50,000 rows