|
What do you mean by "large Access database"? How many records??
Excel is grossly inefficient at storing large amounts of data. Each sheet can only hold just over 65,500 rows. Excel can easily run the machine out of RAM long before you get to "many sheets".
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have over 72 thousands records. So I really need convert database to Excel file having many sheets.
|
|
|
|
|
OK. So see how much memory your Excel sheet will take. I think you'll be surprised. 72,000 records will take 2 sheets. Create a single row that simulates the data you'll be importing, then copy it to ALL the rows in the first sheet. If your survive that, go to the second sheet and try to fill in the first 10,000 rows. Depending on your system, you MIGHT be able to fill it in...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hic hic, it is overflow when I run it.  Is there any way to load database from into Excel sheet not row by row? I have tried to do that and it is OK if my database is smaller than 65.000 rows. How about over 72.000 rows?
|
|
|
|
|
chau198 wrote: Is there any way to load database from into Excel sheet not row by row
Nope. The only way you're going to handle the overflow onto the next sheet is to import the database, row-by-row, in your code. This, of course, will take an eternity in Excel.
Excel is just not a good candidate for handling this many rows. It's not what it was designed for. You're better off leaving the data in Access and using other methods for whatever your doing.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi,
Does anyone know where I can find the DotNetNuke DAAB code? I have downloaded the source SDK, and I am looking for examples on how they insert, update, and delete records using Microsoft's DAAB. I have search through the various namespaces, but could find nothing.
Regards,
ma se
|
|
|
|
|
Why not Google for "dotnetnuke DAAB[^]"?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Please help me how to set connection pooling in vb6.0 and backend sql server?
-- modified at 7:57 Monday 17th July, 2006
|
|
|
|
|
A LOT more detail about what your doing with connection pooling is required. By default, ADO.NET does this automatically. But in a single-user app, unless your doing LOTS of database transactions in a short amount of time, connection pooling won't do you much good. It's biggest performance benefit only works server-side, such as in a web application where many clients are asking the website to connect to the database quickly at the same time.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
HIE,
I 'm making a address book type application and i need to add an export to word function.I want to be able to write data into a table in a word file.Is this possible and how would i go about it?? if it is possible??
I had a wierd idea .. what if i made the table in a richtextbox (i dont know how to do that~!)And then write that data into a .doc file?.
also what about just printing the table .. what do i have to look up to just make a File->Print fuction that would have the table printed!??
i really need this please , this is the third forum i've put this question on!!
i atleast need the print question answered!!! i really need this PLEASE!!! 
PS . i need to know how to do this in VB6 code cuz.. i'm still not very clear with .NET concepts!
Thanks
Gideon
-- modified at 13:25 Friday 14th July, 2006
|
|
|
|
|
The RichTextBox doesn't know anything about Words .DOC file format, so won't support them. Word, on the other hand, understands .RTF (Rich Text Format) documents without any problem.
You can use the Word COM object model by adding a Reference to the "Microsoft Office ... Object Library". You can then create your table or manipulate Word any way you like. See this[^] for an example.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
ok , i got the source!
Sub OptimizePerformance(ByRef doc As Word.Document)<br />
doc.Windows(1).View = wdNormalView<br />
With doc.Application<br />
.Options.Pagination = False<br />
.ScreenUpdating = False<br />
End With<br />
End Sub
wat does word.document refer to!?? a .doc file!??
plz reply quick i really need this! 
|
|
|
|
|
giddy_guitarist wrote: wat does word.document refer to!?? a .doc file!??
What does the name suggest to you? Of course it does! It's not the file though, it's represents one of the documents Word has open.
giddy_guitarist wrote: plz reply quick i really need this!
Then call a consultant. The forums on any site are an all volunteer effort. People do not man these forums 24 hours a day, just waiting for a question to pop up. We answer them whenever we can, in the time we have available to us. We all have our own lives too...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi everyone!
I need to display the save changes message box in my windows form if user try to close the form without saving data.so can anyone help me to do this pls/
|
|
|
|
|
ok , first You have to set a flag/variable to go "true" when theres a change
Then u add the code :
<br />
Private Sub Form_Unload(Cancel As Integer)<br />
If change = True Then<br />
Select Case MsgBox("The text has changed." + Chr(13) + "Do you want to save the changes", vbYesNoCancel")<br />
Case vbYes<br />
'Code for saving <br />
Cancel = 0'This unloads the form<br />
Case vbNo<br />
Cancel = 0'Same here<br />
Case vbCancel<br />
Cancel = 1 'This stops the form frm being closed!<br />
End Select<br />
End If
 Hope that helped!
Gideon
|
|
|
|
|
Thank u for helping.
But i have created the module module coding as follow
<br />
Module T_Module<br />
Public Function SaveChanges(ByVal callingform As Form, ByVal datachange As Boolean, Optional ByVal text As String = Nothing) As Integer<br />
Dim message As String<br />
Dim reply As Integer<br />
Dim fbid As String<br />
Const QMark As String = "?"<br />
If text = Nothing Then<br />
message = "Do u want Save thease Changes"<br />
Else<br />
message = text<br />
text = message<br />
<br />
If text.Substring(text.Length - 1) <> QMark Then<br />
text &= QMark<br />
End If<br />
<br />
End If<br />
reply = 1<br />
<br />
If datachange Then<br />
<br />
Select Case MessageBox.Show(text, "Data Changed", MessageBoxButtons.YesNoCancel)<br />
Case DialogResult.Yes : reply = 0<br />
Case DialogResult.Cancel : reply = 2<br />
End Select<br />
End If<br />
Return reply<br />
End Function<br />
<br />
End Module<br />
Then in my windows form coding as follows
//this method is for when user close the form
Private Sub Form_closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
Select Case SaveChanges(Me, datachange)
Case 0
If Not DataSavedOK() Then
e.Cancel = True
End If
Case 1
Case 2
e.Cancel = True
End Select
End Sub
Private Function DataSavedOK() As Boolean
datachange = False
Return True
End Function
And i laso created the two variable
one is dim formload as string,datachange as string.
Then i decalre the forload variable into form load.
Actualy this coding also give the correct result but,if i click yes button in the message box i want to update the sql database but unforunatly it doesn't work at all.(Not displaying any errors also)
Pleas can u help for this.
|
|
|
|
|
I have an application developed in vb.net 2003, using .NET framework V1.1
Some users are now reporting that it will not install on a machine which only has .NET framework V2.0
Can I do anything to work around this and allow to app to work with either framework on the target machine?
Thanks,
Mike
|
|
|
|
|
Have the users intall the 1.1 framework on their machine. They can both be installed at the same time with no issues.
Mike Lasseter
|
|
|
|
|
In the short term I have told them to install V1.1 framework as well as 2.0 but is there no way to allow the code to run with V2.0 or are they completely incompatible?
MS don't help by only showing V2.0 download on the main .NET page
|
|
|
|
|
Hi
In a VB2005 appliction i'm using a third party webservice without problems.
Now this party wants us to add an element to the SOAP envelope so that they can distinguish between the vendors using the webservice.
As an example they added a pieceof jave code (see below)
But how do i do this is VB.NET?
peter
// Construct the header
QName headerName = new QName(" http://ech.client.nl/vendor", "Vendor");
SOAPHeaderElement headerElement = new SOAPHeaderElement(headerName);
headerElement.setValue("ECH Gui");
headerElement.setMustUnderstand(true);
try {
Message message = arg0.getCurrentMessage();
message.getSOAPHeader().addChildElement(headerElement);
} catch (SOAPException se) {
logger.error("Kan niet SOAP header 'Vendor' toevoegen", se);
}
|
|
|
|
|
How to filter dataset and update those filtered records
Thanks
|
|
|
|
|
Hi,
We can filter the Data from DataSet as follows..
1. Fetching Filtered Data and Filling to DataSet.
-------------------------------------------------
OleDbDataAdapter1.SelectCommand.Parameters("ACNo").Value = "60891234"
OleDbDataAdapter1.Fill(DataSet11)
2.
Dim FilRows As DataRow() = _
Dset.Tables(0).Select("ACNo='60891234'", "ACHName", DataViewRowState.Added )
Dim r As DataRow
Dim c As DataColumn
For Each r In FilRows
For Each c In r.Table.Columns
Console.Write( "\t {0}", r(c) )
Next c
Console.WriteLine()
Next r
Notes :
-------
"ACNo='60891234'" = Condition for Fintering Data
"ACHName" = Column to Sort The Data.
With Regards,
Pandian S
|
|
|
|
|
Thanks Pandian for ur prompt reply below is my code. Actualy i wanted to modify filted dataview. can u give some suggestion on this.
daConverstion.SelectCommand = scmdConversion
daConverstion.Fill(dsConversion, "Duplicate")
Dim MyDataView As DataView = New DataView(dsConversion.Tables("Duplicate"), "Duplicate_Group_Id=100", "Duplicate_Group_Id", DataViewRowState.CurrentRows)
MyDataView.AllowEdit = True
MyDataView.Item(0).Row(0) = "11"
|
|
|
|
|
I am having a XML file.
I wish to create a class in VB.NET, dynamically.
The name of all properties will be same as tag names in HTML file and value of that property will be value within tags.
Ex. Consider part of XML file as follows.
<name>Kumar
<age>27
.....and so on
Now when I create a class from it,
I should have someting like this
Lets say obj is object os class.
obj.Name
obj.Age
and value of obj.Name should be "Kumar", obj.Age--"27" and so on
Can any one help me out in this case?
Regards,
Amol
Every thing will come to you if you have faith.
|
|
|
|
|
Hi!Everyone!
Connectting millions of dots to a chart.
And how will you store these dot data so that i could open the chart again?
Best Regards
ICQ:258-235-734
MSN:msnadair@hotmail.com
-- modified at 3:22 Monday 17th July, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
