I’m having an issue with importing my CSV into MySQL, it’s importing but it’s not grabbing all of my data. In the Excel I have 34 unique ID numbers and MySQL is only pulling in 7. In the Excel file if you filter it and count only the IDs that don’t repeat it should be 34 but once it gets to MySQL it only gives me 7.

I went into MySQL and created a database and named it bellaBeats, then I created a table called daily_activity which is what my Excel CSV is called. After it was created I right clicked on database and selected table data import wizard. I then selected my CSV file hit next and then selected create new table and name it daily_activity_merged i did notice it said out of range column value for id and not sure what that means. I’m a beginner in MySQL and I’m trying to analyze my data but I first need to make sure I’m getting it all so any help is appreciated!