Import data From Excel File to Sql Server 2008 Using PL-SQL
Author: Zunnair
In this article I will explain the way in which we can Import Data from Excel file,
This technique did not require any Kind of Format file.
This Article is So Simple to understand
First Create Schema for your Temp table in Sql Server.
After that Set each Column Data Type varchar because while importing excel File we don’t want errors related to data type conversions.
After that write the following Query.
This query insert Excel file records to your database tables. This is very simple and easy Article, I hope you will understand this.