473,666 Members | 2,386 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Showing Progress

HI all,
New to C#.
I am importing data from excel into SQL. Using the folowing command
select * into PLImport6 from OPENROWSET('Mic rosoft.Jet.OLED B.4.0','Excel
8.0;Database=C:/work/data/opex06det.xls', 'SELECT * FROM [dataimport2]')
There can be anywhere betweenn 1000 rows to 800000 rows. Is there a way that
I can shwo the progress of this import

Thanks
Robert
Jun 29 '06 #1
0 952

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2063
by: ssp | last post by:
Dear all, I'm dealing with a very tricky problem and can't seem to find the answer with google. the problem is: i want to store huge data (binaries) inside a mysql databases blob - to later store those data to a file somewhere else (from where i can connect the database). problem comes into play, when I try to output a "progress" of the reading of this data (kind of "xx bytes of XXX bytes already transmitted").
4
11784
by: Scott Lundstrom | last post by:
I have a large amount of data I'm dropping into a dataset and would like to find a way to at the very least show the user that the program is working at retrieving the data and not locked up. I have been unable to find a way to do this with a progress bar so I thought that I would try to disply a message with an animated gif, but I cannot get the gif to animate while the dataset is being filled which is not doing me any good. Any...
0
1300
by: neil | last post by:
Hi, does anyone know if it is possible to get progress when adding a DirectoryEntry.SchemaFilter? I am adding one to extract the computer names on a Server 2003 box and would like to show a progress bar or similar, as this seems to take a number of seconds to complete (5-10) thanks Neil
8
3269
by: Raed Sawalha | last post by:
I have form with progress bar ,when application begin processing and progress bar moving if I minimized the form and try to restore it ,it is not showing until the processing completed ,how can I enabled minimize, maximize moving form while processing in underway?
2
1521
by: Matt Culbreth | last post by:
Hello, I've got a fairly typical request to show a "Plese Wait" page while a long process is running. In this case, the user fills out a form, presses the button, a process searches for items, and in about 6 seconds it is returned. I've read up on the normal ways of doing this with a new Thread() or with a META tag to refresh the page, but it seems most of these methods use Session. We're not using Session at all in our web
2
9188
by: Dinesh Jain | last post by:
Hi all , As we run the .NET exe, first of all it loads all the necessary system dlls and user dlls at load time and then displays the main form of the application. But in between loading these dlls and displaying the main form , it takes some good amount of time. So I want to display progress bar in between. is it possible?
2
2948
by: Robert Smith | last post by:
Hello, I have a problem with my progress bar, as shown in the attached code, the values on the bar are incremented within a threaded timer event. The timer works fine and ticks all the way through. However when you Add a new status bar to the form with a Progress bar and then immediately perform some intense programming that uses a lot of processor resources, the bars in the progress bar are not displayed, even though the timer appears to...
6
1793
by: Vikas Kumar | last post by:
Hi if I want to show a progress bar in my web application how can i do it Like this much % of task has been completed as its shown when installing some desktop application i want to do same in my web application
3
1421
by: ConieFL | last post by:
In my main sub routine I have code similar to this Form.Show Call File_Routine The file routine searches for a configuration file, needed by the program. If the configuration file is not found then the file routine continues to search for certain files so that there paths can be stored in a newly created configuration file. While the program searches for the files, I am trying to display progress messages to the user. The problems...
1
4110
by: =?Utf-8?B?SmV0aHJv?= | last post by:
Currently using LogParser 2.2 via C# (VS2005 with .NET Framework 2.0) to search for specific errors in very large IISW3C logs. Program is functioning as intended but the size of the logs causes very long processing times and since all results are being written to CSV, there is no visual indication of progress whatsoever. I searched the www and am not having luck finding any advice on how to add a progress indicator for LogParser. Thanks...
0
8440
marktang
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...
0
8355
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8866
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8781
jinu1996
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...
0
7381
agi2029
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...
1
6191
isladogs
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...
0
5662
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();...
0
4365
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2006
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.