SQL in Excel data
Is there a possibility/way to run an SQL query in an excel data sheet?
I have quite some data like the sample below, now i would like to have the
sum of spending for each person. Like it is possible in Access.
Advice would be appriciated.
You could use a formula like this ...How is the 'FROM' field supposed to work in 2003?
I've noticed in inconsistent behavior of how the FROM field works when
sending messages in Outlook 2003.
From my testing it seems like on some occasions it will look as if the
message has actually come from the name I enter into the field. I.e. 'John
Smith' however on other occasions it will say sent from 'Myself' on behalf
of 'John Smith'.
Can someone confirm how it is supposed to work in an IMAP environment?
On Thu, 16 Dec 2004 00:46:07 -0000, Maz wrote:
> I've noticed in inconsistent behavior of how the FROM field works when
> se...How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from
the following XML file:
<?xml version="1.0" encoding="utf-8" ?>
There will be more data than just a name for each Parameters node. Here is
Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...Love Potion for Miss Blandish #13
yada yada hi darmasya,
...Custom Item Movement Report
Anyone out there have a custom item movement report and item movement
history report that includes extended description that they would be willing
That was a pretty tricky request but I was able to make the change.
Download the reports here:
If you cannot download from there shoort me an email and I will send
over. Check out our RMS add-ons website in exchange..
New West Technologies
Can you do one with "Transferred To"...Custom cell formatting
I need to create a custom format for a series of cells that will begin like
I can't figure out what the code character is fora volitile potentially
Can anyone help me??
something like this might work for you but you'll need to put all the
leading digits in for the entry with the alpha character
"MDavison" <email@example.com> wrote in message
> I need to create a custom format for a series ...Is anybody using Symantec Enterprise Vault?
A vendor has recommended this solution to us, I have looked at the datasheet
for the product and it speaks the right language but I was wondering if
anybody on here uses it in a live environment and what their opinion of it
...Missing Menu Options (Outlook 2002)...
I've noticed a few things disappearing:
1) When I right-click an e-mail to add the person to the
Junk Senders list, the options under "Junk E-mail" are no
longer visible (just gives me a stubby blank box)
2) I don't have access to "Tools --> Rules Wizard" -
that'c completely disappeared.
...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from
the contact gets empty.
Anyone has the same issue?
...Ex5.5 to Ex2003 intra org migration
I have migrated from E5.5 to E2003 intra-Org migration and chose the option
SID migration via ADMT during migration .
I 've notice that both source domain and target domain accounts have been
added to mailbox and public folder resources which doesn't appear to be a
problem at the moment. However in the near future when I do decide to remove
the source domain would I be left with "zombie" source domain accounts???
In addition, granted that I chose to migrate SID history what will be the
result when the source Doman is remove. Will there be any performance impact
??...Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be
missing something here. Some data on vendor numbers changed. Let’s say IBM
used to have a vendor number 12345 and now it’s vendor number is 56789. I
can identify IBM as IBM, but I really want to use the number, not the name.
Should I set up a table that ties the numbers together, so that Access knows
12345 = 56789? Or, should I do some kind of Update Query and change all
incidences of 12345 to be 56789? Or, is there some other, method, like a
‘best practices for missing data’?
...Custom CRect Question
I have a custom rectangle class that inherits from CRect:
class CCustomRect : public CRect
CCustomRect(RECT* source, CPoint pt, COLORREF rgb);
void Update(RECT* r);
Inheritance has worked well until I found myself needing to create the
RectBase function (above) to return the rectangle dimensions.
CRect does not seem to have any methods that can be called to return the
base class's RECT value.
I could take CRect::Size and construct a rectangle to return, but this seems
a bit much.
My...Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office
Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders
File (.pst). I understand the basic "Office Outlook Personal Folders File
(.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002
Personal Folders File (.pst) to create a new Outlook .pst file that is
compatible with earlier versions of Outlook."
When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003,
when adding PST's you can chosse either of the two file type options and
browse to chos...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...tasks entered in taskpad don't appear in task folder
All of the tasks that I have entered via the taskpad do not appear in
the task folder, what am I doing wrong or do I have the wrong
What view are you using on your Tasks folder?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
"John Keith" <firstname.lastname@example.org> wrote in message =
I'm about to pull my hair out. I have no problem accessing system
attributes, but the second I try to get or set a value for a custom
attribute, I get an error (null or not an object). My problem is I am
checking the changed input to a field, and if it fails a certain
criteria, I need to reset the original value. The best way I could
think to do this was to store this value in a new attribute and then
restore it if needed. Any help would be greatly appreciated.
> I'm about to pull my hair out. I have no problem accessing system
> attributes, b...Find what control is using a data item
I built a form, then deleted 2 columns from the source table and now I get a
popup asking for the value of those 2 columns. The problem is, I don't use
those columns so I need to find what on the form is refferencing the deleted
I have looked at the control drop down on the properties window and the tab
order window and can't find a control with either one of the missing column
How do I determine what is trying to refference the deleted columns?
I found the problem, the column was still referenced in the underlying query
that fed the form.
"MeSteve"...Migrating E5.5/NT4 to E2003/W2K
I am going to be migrating E5.5 to E2003 very soon
Can anyone please give me tips
as I would like to avoid as many probs a possible.
I can use the same IP, Domain name etc
Thanks in Advance
Done a few of those You could do an in-place upgrade but you must be
absolutely sure about your backups. For me, the easiest (and probably
safest) way is to do a new installation of 2003 and run the two systems in
parralel until all users have been migrated to the new system before
shutting down the old system.
Suppose you have email@example.com as your current e-mail domain:
1. Create a...Exchange 2003: Missing emails
Strange problem, not sure if anyone else experiencing:
We are running Exchange 2003 SP1 on Windows 2000 SP4. A manager came to me
and asked where some files had gone in their folders. I checked through
their mailbox, and sure enough the emails that had been filed away were
missing. Checking through the backups, the email was last in the folder
about 2 weeks ago.
Does anyone know how i would audit what has happened here? i am not asking
what has happened to these emails, but moreso who has accessed this mailbox,
and when, in the last 2 weeks,
thanks in advance
Did your...sent and received fields
I've just switched from Outlook Express to Outlook 2000. In one of my
folders, I have sent and received emails that I want to sort together based
on the sent or received date, but all my sent emails sort together because
the received field has no value. And the same for the received emails. Is
there a way to combine these fields or tell Outlook to sort based on both of
them? Do I need to write a VBA macro to accomplish this?
...Option for fields to show up in datasheet view
Since most people are more familiar with excel then access, my users prefer
to see it in datasheet view. However, since it could be too long, anyone can
help me how to make an option to show up only field that we can chose in the
I remember there is a sample of database that has that one, but I do not
know where is it now. Please help.
Thanks in advance,
Simplest solution might be to set the Visible property of the controls on
the form, based on the fields the user wants to see.
Allen Browne - Microsoft MVP. Perth, West...merging data
I'm new to this forum and to to Excel (2000) and not sure that I'm
asking this question correctly but here is what I'm trying to do.
The data on my work sheet is pasted from another sorce and includes
information: name, ref #, time, date. I use this information looking
up the status of an order and enter a "status note" in 5th (last)
As the day progresses, the source that the data comes from is copied
and pasted under the current list I already have going and much of the
data on the lower list is a duplicate. How can I merge the to list so
that I hav...Olutlook 2002
I've used the customize settings feature in Outlook Today to use "Summer
Theme" but each time I start up it comes up in the standard theme. I
can open the customize settings and close it and "Summer Theme" is
there, but then I switch to mail and back to Outlook Today, I'm back to
the standard theme. I've checked the registry and the setting is
supposed to yield Summer Theme. Anyone know what's causing this
problem? I really like the Summer Theme better than standard. Any help
would be appreciated.