https://community.qlik.com/t5/Talend-Studio/how-to-import-csv-file-into-MYSQL-DB-table-with-automatic/m-p/2262883#M43205 Fully automatic - not <BR />You can add file schema to repository - and then it guess schema for You, after this You will need check and fix if any mistakes <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MCIw.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151918iC8950DEAA57C94FE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MCIw.png" alt="0683p000009MCIw.png" /></span>&nbsp; &nbsp;&nbsp; <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MCJ1.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149913i36E4868081D7A03E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MCJ1.png" alt="0683p000009MCJ1.png" /></span>&nbsp;&nbsp; <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MCJB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152176i44D44E76F961D82A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MCJB.png" alt="0683p000009MCJB.png" /></span> Tue, 15 Nov 2016 12:06:19 GMT vapukov 2016-11-15T12:06:19Z https://community.qlik.com/t5/Talend-Studio/how-to-import-csv-file-into-MYSQL-DB-table-with-automatic/m-p/2262882#M43204 hi all..<BR />An advice needed to import csv file into a MYSQL DB table.<BR />In my csv there are 200 clms,<BR />Is there any way that automatically assigns datatypes for the clms in MYSQL while importing csv file as in MS SQL SERVER.<BR />Thanks&nbsp;<BR />VK Sat, 16 Nov 2024 10:15:18 GMT https://community.qlik.com/t5/Talend-Studio/how-to-import-csv-file-into-MYSQL-DB-table-with-automatic/m-p/2262882#M43204 Anonymous 2024-11-16T10:15:18Z https://community.qlik.com/t5/Talend-Studio/how-to-import-csv-file-into-MYSQL-DB-table-with-automatic/m-p/2262883#M43205 Fully automatic - not <BR />You can add file schema to repository - and then it guess schema for You, after this You will need check and fix if any mistakes <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MCIw.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151918iC8950DEAA57C94FE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MCIw.png" alt="0683p000009MCIw.png" /></span>&nbsp; &nbsp;&nbsp; <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MCJ1.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149913i36E4868081D7A03E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MCJ1.png" alt="0683p000009MCJ1.png" /></span>&nbsp;&nbsp; <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MCJB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152176i44D44E76F961D82A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MCJB.png" alt="0683p000009MCJB.png" /></span> Tue, 15 Nov 2016 12:06:19 GMT https://community.qlik.com/t5/Talend-Studio/how-to-import-csv-file-into-MYSQL-DB-table-with-automatic/m-p/2262883#M43205 vapukov 2016-11-15T12:06:19Z