"EMW" <someone@microsoft.com> wrote in message
news:3fb52960$0$79332$5fc3050@dreader2.news.tiscali.nl...
> The MSDN is a great source of information for programmers of .NET
> applications, but not for the simple things!!!!
>
> I have been searching for a few days now, my desk is filled with printouts
> from books, help pages and web pages, but still cannot find what I'm
looking
> for.
>
> I'm trying to write a little program, to practice VB.NET, to convert a
table
> from EXCEL to an ACCESS DATABASE.
> I managed to find some examples on how to create a database using ADOX and
I
> managed to fill a datagrid with the contents of the EXCEL file.
>
> Now I'm trying to find out how to move the info from the datagrid to de
> database in a simple and jet fast way.
>
> All the books, web pages and help pages I've been reading all contain
> samples on how to open the NorthWind database (which I now really hate),
but
> nowhere is there a sample that shows how to create a new table, write
> something in it and close the database.
> And they also always talk about SQL servers which I don't have.
>
> So you now get my frustration.
>
> Can someone please help me, before my insanity becomes permanent?
>
> rg.
> Eric
>
>

"EMW" <someone@microsoft.com> wrote in message
news:3fb52960$0$79332$5fc3050@dreader2.news.tiscali.nl...
> The MSDN is a great source of information for programmers of .NET
> applications, but not for the simple things!!!!
>
> I have been searching for a few days now, my desk is filled with printouts
> from books, help pages and web pages, but still cannot find what I'm
looking
> for.
>
> I'm trying to write a little program, to practice VB.NET, to convert a
table
> from EXCEL to an ACCESS DATABASE.
> I managed to find some examples on how to create a database using ADOX and
I
> managed to fill a datagrid with the contents of the EXCEL file.
>
> Now I'm trying to find out how to move the info from the datagrid to de
> database in a simple and jet fast way.
>
> All the books, web pages and help pages I've been reading all contain
> samples on how to open the NorthWind database (which I now really hate),
but
> nowhere is there a sample that shows how to create a new table, write
> something in it and close the database.
> And they also always talk about SQL servers which I don't have.
>
> So you now get my frustration.
>
> Can someone please help me, before my insanity becomes permanent?
>
> rg.
> Eric
>
>

> Eric,
>
> There is no shortcut to success.
>
> ADO.NET is what you need to populate your database. ADO.NET lets you write
> your code - simple and bad - should you need it,
> or well laid out and verbose - should you choose to do it.
>
> I recommend a book on ADO.NET by David Sceppa.
>
> If you want a "quickfix", do this.
>
> You have your excel loaded in a dataset (I presume you were able to do
this
> much).
> (Using Oledb)
> Now create a datacommand.
> Put relevant commandtext in it.
> Obviously the right d/b connection as a connection object
> do command.executenonquery.
>
> THATS IT DUDE !!! NOW CHILL :)
>
> - SM
>
>
>
> "EMW" <someone@microsoft.com> wrote in message
> news:3fb52960$0$79332$5fc3050@dreader2.news.tiscali.nl...
> > The MSDN is a great source of information for programmers of .NET
> > applications, but not for the simple things!!!!
> >
> > I have been searching for a few days now, my desk is filled with
printouts
> > from books, help pages and web pages, but still cannot find what I'm
> looking
> > for.
> >
> > I'm trying to write a little program, to practice VB.NET, to convert a
> table
> > from EXCEL to an ACCESS DATABASE.
> > I managed to find some examples on how to create a database using ADOX
and
> I
> > managed to fill a datagrid with the contents of the EXCEL file.
> >
> > Now I'm trying to find out how to move the info from the datagrid to de
> > database in a simple and jet fast way.
> >
> > All the books, web pages and help pages I've been reading all contain
> > samples on how to open the NorthWind database (which I now really hate),
> but
> > nowhere is there a sample that shows how to create a new table, write
> > something in it and close the database.
> > And they also always talk about SQL servers which I don't have.
> >
> > So you now get my frustration.
> >
> > Can someone please help me, before my insanity becomes permanent?
> >
> > rg.
> > Eric
> >
> >
>
>

> The MSDN is a great source of information for programmers of .NET
> applications, but not for the simple things!!!!
>
> I have been searching for a few days now, my desk is filled with printouts
> from books, help pages and web pages, but still cannot find what I'm
looking
> for.
>
> I'm trying to write a little program, to practice VB.NET, to convert a
table
> from EXCEL to an ACCESS DATABASE.
> I managed to find some examples on how to create a database using ADOX and
I
> managed to fill a datagrid with the contents of the EXCEL file.
>
> Now I'm trying to find out how to move the info from the datagrid to de
> database in a simple and jet fast way.
>
> All the books, web pages and help pages I've been reading all contain
> samples on how to open the NorthWind database (which I now really hate),
but
> nowhere is there a sample that shows how to create a new table, write
> something in it and close the database.
> And they also always talk about SQL servers which I don't have.
>
> So you now get my frustration.
>
> Can someone please help me, before my insanity becomes permanent?
>
> rg.
> Eric
>
>

> Hi EMW,
>
> Of course that did work, because you did not get any message which said:
> "don't do it", so you was looking again taking the advices or did it by
> yourself, but you did know it could be solved ".
>
> :-)
>
> Cor
>
>