That is it. I need update dsts from my database. I receive a .xls file from client with the new position of consumers. With your lesson i can update my database. THANK YOU VERY MUCH, and congratulation for this job.
doing foreach column and updating or inserting results many queries when working with thousands of records, :( is there a cleaner and optimized version for this?
Great video, thank you so much... If i would want to add and edit some rows at the same time.. is it possible? for example could I export the file, add a new row and import back? I'm waiting for your answer.. thanks!!!
Hello and thank you very much for this tutorial but I have a concern most of the time we import and export with the HeadingRow I would like to know how to do the same with the Update of the EXCEL file
The video is very clear, thank you. When I try this using SQL Server I get this error: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type nvarchar to bigint. (SQL: select top 1 * from [schedules] where [schedules].[id] = import) No matter what I do, cannot pass it. It is an issue with the Database? Thanks for the help.