Click here to Skip to main content
15,879,535 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HI,
I want to import my all excel sheet data to sql table.
i am using MS OFFICE 2007 and MS SQL SERVER

How to do this.
C#
excel sheet name-sample bill

Columns in Excel -Client Name,Project Name,Bill No.,Bill Date

table name - tempprojectdetails

Columns in SQL table -  Client Name,Project Name,Bill No.,Bill Date


how to do this ...
Thanks in Advance.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900