How to load data from Excel to database without using SSIS package.

Hi Friends,

I have 5 tables in Academy database.

Like Academy details tables,Academy Students table,Academy Student Parents table,Academy class,Section Table,Academy Staff table.

I have created the tables and data into the database.

And Now I need to prepare a Excel sheet to upload data into the these tables.

Can anyone please help me out how to prepare the Xlsx sheet and how to upload into database without using SSIS package.

Tha

May 26th, 2015 3:39am
samples in this article import Excel data by using:
  • SQL Server Data Transformation Services (DTS)
  • SQL Server linked servers
  • SQL Server distributed queries
  • ActiveX Data Objects (ADO) and the Microsoft OLE DB Provider for SQL Server
  • ADO and the Microsoft OLE DB Provider for Jet 4.0

Refer

https://support.microsoft.com/en-us/kb/321686

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2015 3:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics