C# Tutorial - Import data from Excel to SQL Server | FoxLearn

How to Import data from Excel to SQL Server using Z.Dapper, ExcelDataReader in C# .NET Windows Forms Application.

import data from excel to sql server using c# windows application

[dinaldomichinge]

Please can you share de code, i facing trouble on ready object, the method "AsDataSet". I want see the import part. I already was i your web page i saw the code but the import part is cutted.

[mafmaf]

an error occured while retrieving the InformationSchemaTable information. See the inner exception for details.

i get this error when i click the import button at the end. i checked every code and any detail may help online but stucked. i need some help.

[shomari]

whats the difference between Dapper ORM and Z.Dapper please

[cabalsdemon]

on8:28 where you add your

it keeps telling me the name table doesnt exist in the current context
and i have typed word for word can you please help me

[furkanguney]

Would Datatable work instead of class?

[EJSP]

Hi, ¿How I can do this, but having more excel sheets in the excel file, and each sheet have to import to a table in SQL?, thx

[KristinaKristina-cfll]

Hello, I already have the data in the database.how to add data from excel in this case?

[julsfadriquelan]

how about the updating the table by importing the new and updated csv file ?
do you have any tutorial on that ? thanks for the reponse

[ayyanar]

What i say about you...Previous Comments will say all and Your the Best FoxLearn.

[nagaprasannaeluri]

Hi, I have tried this it is taking more time to execute dB.BulkInsert line, not stopping . Can you help me

[simeonbryukhov]

thanks your explanation is very helpful

[playfree]

What shoudl I put to the tableCollection If I want all sheets to be uploaded?

[aunghtay-rgbk]

how to write import data from excel to line chart in C#

[manertermanertering]

can you make a delete button that delete the imported file in the databse

[ashishjog]

Great Tutorial and quality as always, Fox Learn, I am having one issue, the column name in EXCEL contains "Spaces" and Some Special Chars too, e.g. Customer ID, Sr No. etc; so how to add those in class file e.g. shown in 11:55,
public string "ColumnNameWithSpace" {get; set;}
Please help me in this case!

[r]

Foxlearn can u make a tutorial were you make a terminal like cmd? I need to know i wanna make something like that. You can use console C# or just desktop app C#

[mistersimple]

Hello Sir, I am using visual studio 2015 and sql server 2019. I tried to connect it to visual studio 2015 and it worked. However, when I try to open new query in visual studio from sql server 2019 connection, "an incompatible sql version was detected" window pops out. Is it true that both of them are incompatible? Thanks. It also appears when i try to right click the table inside it when i try to show table data.

[clidton]

how to mapping sheet column and class variable means any one choose and map both column before show on datagrid just like sql import wizard

[akshaylate]

System.NotSupportedException: 'No data is available for encoding 1252. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method.' i am getting erroe from this code will u help me

[goverdhanjayaram]

Excellent ! Thank you very much for this video.