Writing data from excel to sql-server
I would like to write the values of A1 and B1 to a SQL-Server table every 10
seconds. How can I do this ?
Svein Olav Steinmo
There's only two ways I know of to do this. 1.) You have
to create a link to the EXCEL sheet in question using MS
SQL Enterprise Manager. Then create a scheduled job to
run an SQL statement to update the SQL table. Note:
Changes to the EXCEL file will update automatically
through SQL link. 2.) Create an Access DB with links to
the respective tables and worksheets. Create a PASS
THROUGH query that updates the SQL table using the EXCEL
I have some XML doc loaded in a C# Web Service.
XmlDocument doc = new XmlDocument();
Code Missing to manipulate header (I would like to replace or manupulate all
Any idea on how to access and manipulate data within the doc header?
> I have some XML doc loaded in a C# Web Service.
> XmlDocument doc = new XmlDocument();
> Code Missing to manipulate header ...Recieving Domain.2 sending Domain.1
I have currently set up my Exchange 2003 server for 2 companies receiving 2
domain names everything is working fine except the users of domain name.2 are
sending their e-mail out as firstname.lastname@example.org how do I correct this so that
they send out email@example.com?
Thank you for your time
On Fri, 29 Jul 2005 06:26:06 -0700, LaOVis
>I have currently set up my Exchange 2003 server for 2 companies receiving 2
>domain names everything is working fine except the users of domain name.2 are
>sending their e-mail out as firstname.lastname@example.org...Illegal Operation #2
Everytime I send an email message, I get an illegal
operation notice. This also happens when I delete
emails. The following are examples of the details of the
illegal operations. Does anyone know what I can do to
OUTLOOK executed an invalid instruction in
module <unknown> at 0000:00ff705e.
EAX=00000000 CS=017f EIP=00ff705e EFLGS=00010297
EBX=00ff686c SS=0187 ESP=0056f1e0 EBP=0056f21c
ECX=00ff686c DS=0187 ESI=0056f210 FS=22e7
EDX=00000000 ES=0187 EDI=00ff705c GS=0000
Bytes at CS:EIP:
8e 30 00 00 00 00 f4 68 ff 00 62 01 00 00 33 00
00ff705c 00f...Problem opening excel 97
When I open Excel 97 I receive an error. Microsoft Visual
Basic- Permission to use object denied. I have tried re-
registering excel with no luck. Any other ideas?
Chip Pearson has a WebPage that offers a variety of suggestions.
Be advised to back up your WorkBook before attempting to make changes.
>W...how to compare two excel files
i would like to know how to compare two excel files.
is there any tool for that?
in addtion is there any way to maintain several versions of the same file
with easy way to have diff between them?
There are a number of programs out in the market that provide more complex
Otherwise you could simply make a new sheet and copy the following formula
anotherway to do it is to run the following you need to set up the workbook
and workshee...Read XHTML into XML
I need to read/parse XHTML aspx pages and look for certain tokens and
content. How can I use a XmlTextReader for this? If not, any other ideas?
Thanks in advance,
Jose Antonio Reyes wrote:
> I need to read/parse XHTML aspx pages and look for certain tokens and
> content. How can I use a XmlTextReader for this? If not, any other ideas?
If the pages are well-formed XHTML then it is possible to use XmlReader
(in .NET 2.0/3.0) or XmlTextReader (in .NET 1.x) to parse the XHTML
documents. You can also use the other XML APIs .NET provides so using
XPathNavigator and/o...excel: real slow to start up
Not sure what's changed but I am finding my Excel takes an age to load
and open a file....
so anyone care to tell me what to look for and how to fix it?
A lot of "slow" Excel problems are caused by too many files in your
Clear out your Windows\Temp folder.(see notes below)
If using WinXP another Temp folder would be in your
Documents and Settings\User\Local Settings\Temp
If you are on a Net, the Temp folder could be just about anywhere.
Notes on deleting Windows\Temp files............
Re-boot to make sure t...How to invoke the xml editor?
I installed vs2005 on a new xp pro machine, and installed everything
except C++. When I click on a file with a ".xml" extension it is
opened with IE. When I click file/Edit with XML Editor, it opens it
with Notepad. If I click File/Open With and select XML Editor, it
opens it with IE. So, where is the xml editor?
Can it be invoked from withing VS? Where?
* email@example.com wrote in microsoft.public.dotnet.xml:
>I installed vs2005 on a new xp pro machine, and installed everything
>except C++. When I click on a file with a ".xml" extension it is
>opened ...Dynamic Excel
Is there anything that I can do in Excel to my Excel report dynamic?
For eg... is it possible to create something which will create results
based on figures keyed in... ? Any suggestions would be welcomed... It
would be good if u could send me similar Excel project of yours... to
me as reference...
Message posted from http://www.ExcelForum.com/
this is a little bit vague :-)
maybe as a starting point:
http://www.ozgrid.com/Excel/exce...how do i hyphenate text in excel
how do I edit narrative entries in an excel spreadsheet format? I.e. how do
I get words to hyphenate automatically in cells?
XL isn't a word processor - there's no built-in functionality for
automatic hyphenation. XL knows nothing about words, punctuation, etc.
In theory it could be done with event macros, but if you're looking for
hyphenation at syllabic borders, they would have to be rather
In article <259E5311-F66B-4DDD-BAE5-87E40D39A625@microsoft.com>,
cjol in WA <cjol in WA@discussions.microsoft.com> wrote:
> how do I edit narrative ent...EXCEL 2003 How to swtch frmttng ptterns for RADAR chrt to border/a
I am creating radar chart comparing my new chart with existing chart
(two different excel files on same computer).
On the old chart legend keys displayed as little squares, on the new -
When I bring up Format legend Key dialog on the _OLD_ chart, on the
Tab Patterns I see two groups: Border and Area. The Sample shows a
rectangle with colored border.
When I bring up Format legend Key dialog on the _NEW_ chart, on the
Tab Patterns I see another two groups: Line and Marker. The Sample
shows a simply a colored line.
Same difference I see in Patterns Tab for Format Data Series dialog...excel forms
Can anyone tell me how you can get a text box to display a number in the
format 0.00 ?
Dim myVal as double
myval = 3
textbox1.value = format(myval,"0.00")
Jim Lavery wrote:
> Can anyone tell me how you can get a text box to display a number in the
> format 0.00 ?
Good evning Jim Lavery
This code will show the value of 100 to two decimal places i
TextBox1.Value = Format(100, "#,###.00")
dominicb's Profile: http://www.ex...I want to use excel to keep track of my book collection, but I have a question...
I want to create a database of sorts using excel to keep track of my book
collection, but I have a question.
Essentially for each book listed on a row I want a column for each of the
following: book title, author, publisher, year, and genre.
I've used Excel before and have seen a spreadsheet with a worksheet like the
above which had a second worksheet that had a button marked "Add book
details" When you clicked it you filled the info above into a few boxes and
then it would actually add the info you typed in, into the first worksheet
and even sorted it into the corr...show XML schema and values
I have an XML document that looks like the following:
What I'm aiming to do is to show the data in a report as in the following
The "Field1-3"-elements can have any name, so I'm trying to get a table that
has in one result column the element name, and in the second colum...Beginner question #2
Please forgive what might be a beginner question.
I have a spread sheet that is made up of 10 columns.
I would like to make it so that each time I change a
number in these columns, the sub-total at the bottom
of each column changes automatically AND so that
the sub-total in the far right column changes automatically.
Is there a template for this??
Thanks so much!!!
You would use a function for that, lets say you have values in A1 to A10,
then in A11 place this =SUM(A1:A10), or =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10.
got the idea??
"jenny" <firstname.lastname@example.org> skrev i melding
ne...Offline synch using XML web-services
This is a bit long-winded. Can somebody read thru these 2 use cases, and
tell me if it is feasible ? :-
Use Case : Replication before Offline Synch
Scenario 1 : Oracle Server , MSDE client
1. User clicks on 'Go Offline'. System creates a MSDE SQL database in
laptop (client), gets the schemas of the tables in Oracle, creates
corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL
2. Offline replication program reads in the tables of the server into a
typed datasets, converts the typed datasets into XML, and stores the XML in
the client. (XML serial...how to preserve formatting from Access 03 to Excel 03
Has anyone been having issues with exporting a report from Access to Excel,
and the data format changing? If so, and you have fixed the issue, please let
...excel 2003 no of cells
DOes anyone know if the size of a worksheet in excel has increased in 2003
version compared to 2002.
We have some reports that are bigger than excel but cannot find any info re
the size of the new version.
Hope someone can help !
Thanks in advance
Same size - 65536 rows and 256 columns.
"Carolyn Bromley" <anon@anon> wrote in message
> Hi !
> DOes anyone know if the size of a worksheet in excel has increased in 2003
> version compared to 2002.
> We have some reports ...XML Serialization ... how to truncate <?xml...
While xml serializing object how can I truncate <?xml ...?> this line alone?
I need to send the serialized xml data to a web method ... since SOAP
already have <?xml tag there was some confusion
Any help would be greatly appreciated
> While xml serializing object how can I truncate <?xml ...?> this line alone?
Serialize to an XmlWriter created with XmlWriterSettings where you set
OmitXmlDeclaration to true.
Martin Honnen --- MVP XML
...How do I set up a formula to insert text in excel?
Hi, I have a questionnaire that is administered on an excel sheet with
respondents typing their answers (i.e 1,2,3) into specific cells. Is there
any way that I can create a formula (or something??) that inserts response
relevant text into another sheet in the workbook, to create a report?
You can use formulas for this type of thing if you want this done only
once. But if this is a repeating task I would suggest an event macro. If
you want to use an event macro you will have to decide when you want this
copying to take place. IOW, what event do you want t...How to forward email #2
Wondering where in 5.5 can I setup mail forwarding. I have an employee who
was discharged and I would like to have all her incoming mail forwarded to
the designated user. I would rather use forwarding as opposed to adding her
mailbox to that users profile. Any suggestions would greatly be appreciated.
Thanks and have a great day,
There's a section on the properties of the mailbox where you can configure
an Alternate Recipient. Define the designated internal user (pick from GAL)
and that's it.
"Marcus Feldmore" <MarcusFeldmor...Beginner of XML
I am a beginner of XML.
I want to group some files together with a xml file. (it includes a text
file, and an image file and a video file)
Can someone show me some guidelines?
...Why does my excel chart appear in gray when I copy it?
I want to copy an excel chart into powerpoint. It is a simple column chart.
However the columns contain a color gradient. When I copy the chart to the
clipoard, the columns turn into gray. This problem however does not occur on
other computers using the same excel version (2003).
There are about 30 ways to copy and paste charts from Excel into PowerPoint.
The problem you are describing is not one I have heard of - namely that it
works on one machine but not another. However, you could try a different
method of copying. For example - you can use the Camera tool to copy a
...SmartList Export to Excel Opens Another Instance of Excel
Client just moved from SP1 to SP2 on v9 Dynamics GP. Also using Excel 2003.
Complaint is that while on SP1, they could export from SmartList to Excel;
with Excel adding workbooks to the current Excel instance. Through the
toolbar window, they could easily flip through workbooks (they have several
various exports throughout their daily routine).
However, now with SP2, each export will open a new instance of Excel. This
results in several Excel programs open at the bottom of the screen, with each
containing only one workbook.
Although this may seem trivial, it does make it inco...