764 0 0 0
Last Updated : 2024-04-23 08:14:11
From Excel to SQL Query
If you have data in an Excel sheet and would like to create a sql query to add/insert data here is the way,
="INSERT INTO consultations (title, description, department, startDate, endDate, profilehyperlink, report,status) VALUES('"&A2&"','"&B2&"','"&H2&"','"&TEXT(C2,"YYYY-MM-DD")&"','"&TEXT(D2,"YYYY-MM-DD")&"','"&F2&"','"&G2&"','"&E2&"')"Read Also
Mohammed Anwar
Experienced technical lead PHP, MySQL and Laravel Developer for 15+ years, with proven ability to develop and create high-quality and optimized web applications. Great ability to build and optimize database design, schema and queries. Versed programing trainer and instructor delivering web courses and helping others to get into the field in a timely manner. Fast and eager learner for new technologies .