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
6  1302 
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.execute nonquery.
THATS IT DUDE !!! NOW CHILL :)
- SM
"EMW" <so*****@micros oft.com> wrote in message
news:3f******** **************@ dreader2.news.t iscali.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
You should (but I haven't actually tried it) be able to create a table in an
access database (assuming you already have a database file) by creating a
connection to your database using the OleDbConnection object, then you can
create an OleDbCommand and set it to use your connection and set the command
text to something like:
"CREATE TABLE mytable ( myfield1 varchar, myfield2 int.....)"
and then use the OleDbCommand.Ex ecuteNonQuery method to run the actual
method. That you create your table with the columns you've specified and
then you can go from there. I'm not 100% sure this is actually supported by
the Access drivers, so good luck.
I agree with you on the NorthWind database though!
"EMW" <so*****@micros oft.com> wrote in message
news:3f******** **************@ dreader2.news.t iscali.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
Thanks!
I'm now chilling..... ;)
"Sahil Malik" <no****@ms.co m> schreef in bericht
news:ec******** ******@TK2MSFTN GP11.phx.gbl... 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.execute nonquery.
THATS IT DUDE !!! NOW CHILL :)
- SM
"EMW" <so*****@micros oft.com> wrote in message
news:3f******** **************@ dreader2.news.t iscali.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
YES!!! I got it working.... I guess it helps putting onces frustration on a
newsserver... ;)
"EMW" <so*****@micros oft.com> schreef in bericht
news:3f******** **************@ dreader2.news.t iscali.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
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
Actually I hit a page in the MSDN showing me how to use the code...
Eric.
"Cor" <no*@non.com> schreef in bericht
news:u6******** *****@tk2msftng p13.phx.gbl... 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: mike420 |
last post by:
In the context of LATEX, some Pythonista asked what the big
successes of Lisp were. I think there were at least three *big*
successes.
a. orbitz.com web site uses Lisp for algorithms, etc.
b. Yahoo store was originally written in Lisp.
c. Emacs
The issues with these will probably come up, so I might as well
mention them myself (which will also make this a more balanced
|
by: doltharz |
last post by:
Please Help me
i'm doing something i though was to be REALLY EASY but it drives me
crazy
The complete code is at the end of the email
(i mean newsgroup article),
i always use Option Explicit
and Response.Expires=-1,
|
by: Gnolen |
last post by:
Hi,
I am really getting crazy here! I just do not get why this happens with
the borders of the td/tr! I just want a border on the bottom of the
rows(or td) but I just can't do it!!! I have tried so many different
ways but I just thought this would do it: td {border-bottom: #000000 1px
solid;} But no! What am I doing wrong? Because I can have a border of a
td or tr in FF, right?!
Thankful for any help here! Table and CSS is below..
|
by: leodippolito |
last post by:
Hello sirs,
I am trying to send a POST request to a webservice on the click of a
button. This will return me an XML document with a list of combo box
items.
The problem: in FIREFOX, when the get the XmlDocument from the
XmlHttpRequest object, I can't access its contents. I keep getting
empty strings and "null".
|
by: Larry Tate |
last post by:
I have had a monstrous time getting any good debugging info out of the .net
platform.
Using ...
..NET Framework 1.1
Windows 2K Server
VB.NET <- is this the problem?
error handling in the global.asax file.
I am seeing articles that say line numbers are in the ..
| | |
by: Praveen |
last post by:
Hi All,
I have made a webservice in C# and it works fine in my machine. I ran into a
crazy problem when I wanted to deploy it in windows 2003 server. I have run
"aspnet_regiis.exe -i" to make sure that the extensions for .asmx file etc
are in place. I am getting http 404 when I give the url for the asmx file.
the http error code is wrong because I am dead sure that the file is there.
could you please let me know what else needs to be...
|
by: sugoi.sama |
last post by:
hi,
i'm having a hellish adventure with PHP5 i hope someone just can help
me out on this... i'm desperate
All i want to do, is to get the index of the returned elements, so i
can acess them and change them
(i'm guessing this is the only way to do this, as i can't change the
element on-the-fly in XPath )
|
by: David Murmann |
last post by:
Hi all!
i just had this crazy idea:
instead of
while cond():
pass
write
|
by: squash |
last post by:
I have spent two hours trying to make sense of this script, called
crazy.php. The output should be nothing because $cookie_password is
nowhere defined in this script, correct? But it actually outputs the
value that other scripts i have running set it to. Why should crazy.php
care what other scripts are running that use that variable name??
<?php
crazy();
|
by: Pekeika |
last post by:
Good morning group,
When I open my Python window, this is appearing instead of the command
line >>>. (I'm somehow new to Python).
File "boot_com_servers.py", line 21, in <module>
File "C:\Python25\lib\site-packages\pythoncom.py", line 3, in
<module>
pywintypes.__import_pywin32_system_module__("pythoncom", globals
())
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
