How to bulk insert CSV data into SQL Server database table using query

[@ashleshatiwari9461]

Very useful content ❤

[@theengineersdesk7930]

Thank you ♥️

[@rachamaduguchaitanya2135]

Good explanation

[@theengineersdesk7930]

Thanks

[@StephenBrincat]

Thanks for the video, what if your file name changes daily as this one where name will be like 2024-09-26T23_10_13+00_00Exp Del & Inv Details Ev 71, and first part is different every day 2024-09-26T23_10_13+00_00

[@BLUEsnowballl]

can someone tell me .. whats the purpose of doing this when i can simply import the dat from csv

[@theengineersdesk7930]

You can automate the process using this

[@BLUEsnowballl]

@@theengineersdesk7930 by automate u mean... if i add something in excel after bulk insert and rerun the insert query i can get that new data as well?? right

[@theengineersdesk7930]

Let's say you have written a stores procedure and scheduled it to run daily which pulls the latest records from CSV and put that into database (obviously you will have to modify the query I showed you to check for recent records), this is useful there