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 ...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...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...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...String to xml document
I was hoping someone can help me with a little problem I can't seem to find
any answers to.
I've got a form wich will be posted. On receiving the post I would like to
parse a formvar to a xml document.
The contents of this formvar (string) will be a valid xhtml document.
Can someone give me a startertip (or more :-)) on how to achieve this?
tnx in advance,
James van der Veen
> I was hoping someone can help me with a little problem I can't seem to find
> any answers to.
> I've got a form wich will be posted. On receiving the p...protection on excel
I have created a form using excel where the users enter a numeric data and
using formula to calculate the data. I wanted to post the excel online for
the user to use it, but i don't want the user to change any contains on the
forms except the input field. In other word, I don't want the user be able
to change the formule structurre. Is there a way to do this on excel?
Thanks in advances
- first select the cells for which you want to allow entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now goto 'tools - Protection' and protec...How do I create a query field in Excel
I have a sheet with 9000 part numbers on it. Is there a way of say at the top
of the sheet having some sort of search box, so I can type in the part# and
it goes straight to that part?
Method1: Using the Filter feature.
-select a cell in the data
-goto menu Data>Filter>AutoFilter
- now your data header has dopdown boxes. From the part# header select the
part#. This will make all show only rows with this part#
-Select column Part#
- menu Edit >Find
Method 3: with code
- In a code module, paste the following sub FindAndGo
Also change the 'CHANGE HERE...excel formula needed
I need a formula to
1) look in colunm a, gather any numbers present in that colunm, even though
most wil be empty
2) then i want them to take that list, get rid of the empty cells and put
that data either into a new table or on another sheet.
Sounds like a sort would work. If you want a function, try this:
Enter with Ctrl+Shift+Enter, not just enter...
If this information was helpful, please indica...