Most likely this isn't the right forum to ask this question, but since there isn't an better one to suite my needs, I'll give it a try.
The person fo whom I writting this program used to keep all his dat in an excelsheet.
I normalized the file and created seperate tables.
Now I would like to load the exsisting data in to the db, but already when filling the first table something goes wrong.
I seperated the needed fields in an seperate xls file and created an csv file from it.
But when executing the statement and checking my db if it loaded correct I noticed that everyting is filled with null values.
Anyone an idea how come?
The query I used:
I included a printscreen of the result too
It's good to be able to use someting, it's better to understand how it works.