how to import excel data to mysql relational table?

50
April 13, 2021, at 12:00 PM

I have developed project in laravel for accounting related activity which has many relational tables with foreign keys in mysql. Everything works fine but the problem is my client has an excel file which has more than 10000 (ten thousand) records like vendor name,invoice number,date,amount etc..

So how can i import all of this data in mysql table? Client already have some tables like vendor name etc,so i've to assign all of the ids to existing invoice records! without doing this,my project will be useless. please help me..

READ ALSO
Laravel dompdf table rowspan on page break not build correctly

Laravel dompdf table rowspan on page break not build correctly

im creating export pdf using tables and rowspans, everything look just like what i wantbut on page break it show like this :

35
Bootstrap Navbar Brand and Links colour not matching when using the whole navbar to change the font and colour

Bootstrap Navbar Brand and Links colour not matching when using the whole navbar to change the font and colour

I am new to css and trying to get my navbar brand and navbar links to look the same size and same colour but when I choose the whole navbar to change the font and the colour every link inherits the font but not the colour also branding stays unaffected

42
My Subpage is not working,instead is showing 404 error(Wordpress Underscorer)

My Subpage is not working,instead is showing 404 error(Wordpress Underscorer)

In my underscorer theme,subpages are not working I think think i declared it correctly

60
ASP.NET iframe routing - loading JS files in incorrect order

ASP.NET iframe routing - loading JS files in incorrect order

I have an issue with JS files being loaded in incorrect order, which results in errors

47