Import data from Flat file into SQL Server table using Stored Procedure

Question

HiI am not familiar in importing text  flat file into mssql data base with column using stored procedureCan you advice me how to do thisThank you in advance Maideen

dharmendr · Accepted Answer

Hi maideenRefer below linkshttpscoderscayblogspotcom201711importbulkdatafromflatfileorcsvhtmlhttpsdocsmicrosoftcomenussqlrelationaldatabasesimportexportimportflatfilewizardviewsqlserverver15httpsstackoverflowcomquestions4425001storedproceduretoopenandreadatextfile

Import data from Flat file into SQL Server table using Stored Procedure

Company

Explore

Follow us

Contact Us