CODEWITHSUNDEEP
c#
user3074125
user3074125

Reputation: 91

How to read data from excel template

I have a excel template am taking it in a datatable i want to read the datatable and save it in database

my problem is data is not well aligned i want to insert data number wise for e.g set of 1 number data then process number 2 data. i have two tables one for saving training details and other for participant

var dtsel = dataTable.Select();

i want to process this dtsel datatable.

Upvotes: 1

Views: 68

Answers (1)

Or Groman
Or Groman

Reputation: 123

i want to read the datatable and save it in database

my problem is data is not well aligned

Then just go ahead and align your data in excel...

One way to do so would be:

  1. Select all your columns in excel.
  2. In data, select the from table/range

enter image description here

  1. Select all your data, go to transform and select the fill down option

enter image description here

  1. Your data should now be well aligned, save the new sheet.

enter image description here 5. Now you can easily import the excel sheet to SQL server, MY SQL or other databases with built in tools

Import data from Excel to SQL Server or Azure SQL Database

Upvotes: 1

Related Questions