VB. net Tutorial import data from Excel to SQL server with source code

[@kylehora6965]

can you help me? it keeps saying columname not found

[@PaulIp]

HELLO System.Windows.Forms.DataGridViewCell.Value.get return Nothing。Am I need to add any code to prevent null data in datagrid? Pls advise how can do it? Thx

[@programmingforeverybody]

Ok

[@blacktrader9983]

Hi, is it possible to use the same code in excel and transfer it from excel to SQL ?

[@emmyhernandez8632]

Hola, como lo podría hacer lo mismo, en una sqltransnacional

[@programmingforeverybody]

what mean transnacional

[@rusanh]

es ara excel2007 y para excel2003

[@martynaustria4027]

Whats the directory of your excel file?

[@programmingforeverybody]

F:\

[@martynaustria4027]

Can you please explain how you get this "Provider=Microsoft.ACE.OLEDB.12.0:" & "Data Source=F: ames2.xlsx:Extended Properties= 'Excel 8.0;HDR=False' Thank you

[@programmingforeverybody]

this statement connect with file Excel 2007 file Excel it's name names2.xlsx exist in F: in computer

[@rusanh]

@@programmingforeverybody aya es para excel 2007 y del excel 2003