Visual Basic .NET Tutorial 53 -How to import excel file to datagridview in VB.NET

[@GAMINGWITHINTELHD2000]

When i run the code it is saying that microsoft.ace.oledb 12.0 provider is not registered in your local machine Please Tell How to FiX It

[@jessicalogsdon2582]

I am getting the message "'Microsoft.ACE.OLEDB.12.0' provider not registered on the local machine" Any recommendations on how to fix this?

[@falgunkuhadia2942]

Jessica Niemann > Your PC is running on a 64 bit processor. Change active debug. go to configuration manager > Active Solution Platform > New > Choose x86 Platform. Debug your Programme

[@pratiksharma5663]

Problem does not seems to be disappearing .. ( Same Error message)

[@danniaki8865]

I am having the same problem please could you help!!!!

[@hanishamizan6198]

yes

[@husseinalihussein2186]

Jessica Niemann download access database engine 64 or 32 depending your system and it will work with you

[@znservices2424]

All file debug but getting this error "The Microsoft Office Access database engine could not find the object [Sheet1$]. Make sure the object exists and that you spell its name and the path name correctly. " Can you help me how to solve it path and sheet number all ok as you said changed

[@razorramzan-inc]

Very calm, knowledgeable and elaborate. Thank you

[@christianlugatiman9226]

"Could not find installable ISAM." plss help :(

[@47prisoner]

to select from multiple sheets just add the sheet no. as shown below, MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$],[Sheet2$],[Sheet3$]", MyConnection)

[@kyo1245]

Could not find installable ISAM. I just tried creating the program, but it said this. Any tips to fix this?

[@mohammedshareef3714]

what is that 12.0 used after provider , Is it a version number of MS office or something else??

[@yasminenaguib2539]

Thank you, But I have "could not find installable ISAM" error message, how can fix it

[@Shuvobroto666]

What if i have 2 datagridviews in one application? I use the the same code with the path changed and it loads but when i work on some further calls like reading cells and searching and selecting i have datatable not found problems. Can u help?

[@George-ep4ed]

Thank you sir, your video is very helping full and educated. Do you have any video of vice versa ( DGV to Excel)

[@Trickmagic1992]

Microsoft.ACE.OLEDB.12.0' provider not registered on the local machine????????

[@simonefiniletti9369]

code.msdn.microsoft.com/Eseguire-una-ricerca-su-3d2a7a48

[@Ja_ajja]

How to fix?

[@nespa45]

if you don't know the name of sheet, how you get automatically this name? (in this example is "Sheet1$")

[@FSHG-3]

When exporting from Excell to datagrid view, excell has no headers. When importing, want first excell row to populate in first row of datagridview, not the datagradview header. How can I import excell into datagridview without the first row of excell populating in the datagridview column header?

[@VictorWembanyamaHighlights]

i got an error saying , "FORMAT OF THE INITIALIZATION STRING DOES NOT CONFORM TO SPECIFICATION STARTING AT INDEX88

[@yt440volts]

Great video But how would I enter values into excel and save them?

[@dontcha8791]

I like your video and thank for sharing your code. What if the data starts at specific row?

[@treypick3981]

Why do I get the following error: BC30451 'GridView1' is not declared. It may be inaccessible due to its protection level. I am trying to open an Excel spreadsheet

[@treypick3981]

Solved

[@bri6460]

Hi. It says "External table is not in the expected format" how can i solve this problem? Please help me

[@carlos22bf]

THANKS BRO !!! it´s very simple and very good explained ... !!

[@marmarquez4556]

i had watched almost all your tutorials sir,it really helps.now i have a question how do you save that to your database???

[@keshavbhat5095]

I'm getting this error while executing "Could not find installable ISAM" please help

[@ucant_stopme4604]

HI, How can i import excel without use a button that mean just show it on the datagridview

[@thshm2938]

how can i multi column filter the imported excel in the DGV with a single text box???

[@sarikahp1067]

hello sir, i don't use a particular software in vb i use an Access and .xlsm files ,so please you tell me sir how can importor send or link MS excel old values data into vb please please sir

[@ankit6600]

and how do I save the dgv to access database.. of of now my dgv is binded to the dgv ...plz suggest a video tutorial..a continuation would be wow..

[@ramilberces2743]

how to clear old data the you extract ? if i do uploading a new excel file the old data are stocked..

[@ramilberces2743]

Solved.

[@ProgrammingKnowledge]

[@LorencsGils]

What if I don't know exactly, what is the name of the Excel Sheet? I mean, how to get the list of all Sheet names and put them f.e. in ListBox?

[@tavoosi1]

hi friend thanks for your teaching but I have some problem in my vb toolbox: I have no "datagridview" in my toolbox just tell me how can I active that tab thanks

[@v_winter3024]

It's under View > Toolbox > All windows forms

[@47prisoner]

and what if i have to import from all 3 Excel sheets ??

[@alyagoot94]

can i add textbox as search number or name ?

[@meghnadesai2490]

Buttons you mean ??

[@fatmabenrejeb3979]

and how to export from datagridview to excel?

[@abarnaabi2975]

How to specify the column(A,B..) data to datagrid. Instead of Select *

[@ivanidora9418]

It's work bro,10q very much, you are great!

[@AhmadNurjati]

how to save it.. ? after load from excel.. ? i'm stuck in there.. pls reply me

[@47prisoner]

just use the the normal way, the way how you save a datagridview to database and it will do the job

[@ithutheriyuma..9616]

Thanks sir this work.. nice work

[@dylan400d]

This is excellent. Thank you and well done.

[@abhijeetlokhande5285]

what to do when path is not been set

[@amitagnihotri77]

Msg got "Could not find installable ISAM" plz help

[@simonefiniletti9369]

code.msdn.microsoft.com/Eseguire-una-ricerca-su-3d2a7a48

[@v_winter3024]

It works perfectly, thank you!

[@iorioriga3069]

how can we search excel database using Visual basic ??

[@chokoyeh]

Sir... how to edit the size of column in data grid view? please reply sir I need your help

[@v_winter3024]

At the upper right side of DGV is the little arrow. When you click on it, there's an option to edit columns.

[@Sfrizzo]

how to import the data in a listview?

[@BhavyaRani-q9p]

Thank you so much!

[@mdkrush]

Works great for me! Thanks!!!!!

[@amolmandavkar08]

Can u make a tutorial on creating more than one company in one application

[@issoufououmarouabdoulraham1534]

Wawww je suis satisfais de Thank you

[@vishnuck1068]

Hello please make a video for exporting data to excel file

[@Nisha_Sharma_862]

I Need help

[@mashaandbeer1472]

Thank you

[@arturolozano3420]

Thanks man.

[@bllueprinter]

thx bro

[@abhijeetlokhande5285]

"C:.." on this line

[@MUSICBYKAIFU]

Do not my dig is big

[@dbgaragedays2664]

Brutal to watch. No substance to this that allows avg person to understand the whole process

[@jhiso1660]

gracias brother me ayudaste con esto [ ("Provider=Microsoft.ACE.OLEDB.12.0;" & ("Data Source=" & (stRuta & ";Extended Properties=""Excel 12.0;Xml;HDR=YES;IMEX=2"";"))) ]solo me faltaba eso aunque no lo entiendo gracias

[@simonefiniletti9369]

code.msdn.microsoft.com/Eseguire-una-ricerca-su-3d2a7a48