Uploading csv files to database

Ask the community
,
1

Hi, I would love getting some tips on how to upload big files (1 million and more lines) to a database.
Its possible to upload 50k at a time but it doesn’t work well for some reason.
I broke the file into 50k lines each but after loading the file not all lines were uploaded and its impossible to figure out witch lines where left out.
And- it take forever!
Is there a better, more productive way to do that?
Ive got about 10 very big databases to upload.

Thanks in advance, Michal

2

I admit that uploading CSV files to a database is somewhat challenging. However, it is not nearly as difficult as remembering the birthdays of all of my grandchildren. Then again, my database isn’t what it used to be.

:heart:

3

You remember the darnest things but dates of 6 little people- to hard?