How do I INSERT data into an excell spread sheet ODBC?
I am trying to use the ODBC excell driver and trying to
insert data into my spread sheet as if it was a data
base. How do I do this and are there any publications of
the functionality of the ODBC driver used to access EXCEL
If you go to the Data menu, Get External Data, New Database Query, th
wizard will start to walk you through the rest of it. You will see
list of databases to choose from and once you select your database yo
will be presented witht he list of tables. Click on a table and yo
will see the list of fields available in that table
Message posted from http://www.E...How to remove Security Notice from Access 2007 Runtime?
Is it possible?
Users of my program does not understand why they need to click "Open"
each time they run program under runtime. I have digitally signed
database and user has runtime only installed.
Imagine if we need to click Open each time we run executable. It is
>Is it possible?
>Users of my program does not understand why they need to click "Open"
>each time they run program under runtime. I have digitally signed
>database and user has runtime only installed.
What is the exact message they ...Can't clear print queue
How do I clear the print queue?
I've tried "net stop spooler" and deleted all in
/WINDOWS/System32/spool/PRINTERS, to no avail.
The OS is XP Home SP3. The printer is HP psc 1200.
"Herzl Regev" <HerzlRegev@discussions.microsoft.com> wrote in message
> How do I clear the print queue?
> I've tried "net stop spooler" and deleted all in
> /WINDOWS/System32/spool/PRINTERS, to no avail.
> The OS is XP Home SP3. The printer is HP psc 1200.
What happened when you...NullReferenceException after Data Migration.
I already posted this question here but not solve my problem. After a simple
test migration some pages of WEB GUI show this error:
NullReferenceException: Object reference not set to an instance of an
I migrate one appointment and one activityparty with participation mask of
organizer for a user. After the migration I can see the appointment on CRM
in the activity list, the calendar day view, the calendar month view, but in
the calendar week view I get this error:
[NullReferenceException: Object reference not set to an instance of an
I've pasted tables from an old document into another document. The tables
now have extra boxes around the text. It looks like a table in a table, but
I can't get rid of the extra boxes. Does anyone have any ideas?
Kare_M, what type of document have you pasted into? It is possible to do
exactly what you think has happened in some applications: paste a table into
a cell in another table. Most likely candidate would be pasting into a table
in a Word document.
> I've pasted tables from an old document into another document. The tables
> no...Data Labels on Filtered Data
I am trying to put Data Labels on a Stock Chart, using a different data
for the chart and the labels (in adjacent columns)
I have tried various add-ins and trials (Jwalk chart tools and power pack,
I have also searched high and low for an answer but all roads seem to lead
The problem is that when I change the data source using the filters the data
source changes ok
but the data labels go skew-wiff.
is there a solution for this? or am I missing something obvious?
Any help would be appreciated.
This looks like a bug in the c...How would I fill blank cells with the data from a previous cell?
Need to fill blank cells in a column with the data from the previous
non-blank cell in Excel 2000. Used to do this in Lotus. Can't seem to get it
try edit>fill>series (select one)
Lotus's is simpler.
>Need to fill blank cells in a column with the data from
>non-blank cell in Excel 2000. Used to do this in Lotus.
Can't seem to get it
One way, assuming you mean you have
or something like that and you want the cell with data to fill in the blanks
below ...HTML mail merge emails show images as attachments
When I mail merge a Word document which has images within
it the resultant emails all have the images as mutiple
How can i stop this occuring?
Thanks in advance
...Hidden source data
Why does my graphs go blank when I hide the cells containing the source
Is there a way to omit this annoying occurrence?
when you go Tools|Options|Charts is there a tick in the "Plot visible
cells only" box?
If there is then deselect that option.
Thank you, Ken!
That did it!
I fumbled around a little until I found out that I had to mark an graph
prior to follow this procedure.
I'd say my spreadsheets looking much nicer when a lot of number collecting
cells are hidden
Due to a malformed e-mail message or other malformed item in the information
store, the Microsoft Exchange Information Store service may crash
periodically. It happens when a staff try to move his mail from exchange
mail box to his personal folders.
Now I have to restart the services - Microsoft Exchange Information Store
every 1 min. I attempt to clean his mail box (not delete) in the exchange
server such that to fix this problem.
Can you perform an "online backup" of the information store? If this is
successful, then the problem is probably related to the structure of ...Re: Where should be the best place to stored Applcation Data Files?
"Giovanni Dicanio" <gdicanio@_NOSPAM_email_DOT_it> ha scritto nel messaggio
> BTW: this post by John Robbins is very interesting reading:
copy-and-pasto - the correct link is this:
And then there's this Vista security discussion from last Friday (cool
On Fri, 8 Aug 2008 18:50:23 +0200, ...clear the list og "open other users folder"
When you use the open an other user folder, it could be a
calendar, the persons name and folder is put into a list
under the menu File/Open. I would like to clear that
numbered list of folders, does anyone know how to do that?
...Why won't data hide?
Why does hidden data still appear when a chart is generated from a pivot
table? How can I make a series disappear when I hide the column in the pivot
If you hide the column manually it will still be displayed in the chart.
Because the chart is liked to the pivot table.
If you hide the column via the field filter the information should
disappear from the chart.
> Why does hidden data still appear when a chart is generated from a pivot
> table? How can I make a series disappear when I hide the column in the pivot
...Best chart to show quarterly forecast vs budget
Could you please give me your suggestions on what would be the best chart to
show quarterly forecast to budget for multiple departments?
I would use a multiple bar comparitor to do that.
It is the 3D bar graph that has one bar in front of the other bar.
> Hi guys,
> Could you please give me your suggestions on what would be the best chart to
> show quarterly forecast to budget for multiple departments?
Thanks! Any other advice?
> Hi guys,
> Could yo...locking data #3
I have 2 column of info. My first column has 100 different items and my
second column has numbers 1 through 100 in sequence. I want to concatenate
the 2 columns and not have the second column of numbers show in the
concatenated column. I formatted the second column's numbers to be white, to
match the cells white backgroung. When I concatenate the columns the
resulting column has the numbers in black again, I need for them to stay white
Thank you in advance
Excel doesn't support that kind of formatting with formulas.
If you converted to values, you could format eac...Home page Performance shows sold investment
Money Plus Premium
On Money's Home page is a section showing "Best and worst performers". In
that section is a fund that I sold completely several months ago. I no
longer hold even one share. Why is it still there? How do I get rid of it?
I don't have that fund in any of my accounts. It's not in Investments to
...Query from RMS data
I am trying to create a Pivot table in Excel, using Microsoft Query linking
to RMS SQL database. SQL stores the date as Date/Time. It becomes impossible
to group in Excel using Pivot Table, by date/time. I want to create a record
in Microsoft query using the date field, but convert to Date only as
dd/mm/yyyy and retain the format as Date and not as Text. I have tried
Left(Date,11) and Convert(VARCHAR,1,101), none of them work. Could someone
help me with the correct syntax. Microsoft query does not recognize MID.
I've had a similar problem. The solution I used was to convert ...How to link cell for value in another cell of pivot table?
In Excel 2003, when I link a cell in pivot table, it copies Getpivotdata
And when I drag or copy this cell, again it copies the formular.
Can you help how to just get the value, then be able to drag to link next
cell and its value?
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:
> In Excel 2003, when I link a cell in pivot table, it copies Getpivotdata
> And when I drag or copy this cell, again it copies th...Using Excel data to create mail merge/report
I have an excel data file which has 4 columns - employee number, employee name, orgcode, and # per org
I have entries for 1 to 14 employees in each orgcode, and the first entry has the total for that org in column D "# per org code", but the rest of the entries in that org code don't have an entry in the 4th column
If it were a simple merge I would know what to do, but what I need ideally is to be able to merge into a letter the information for each org code - or at least to print out a page which lists an org code and the names in that orgcode
Is this possible to do this? I...Sorting Data..HELP!
I am trying to sort my speadsheet by the date. When I sort it only
moves the information in the colum with the sort information instead of
the whole row. How do I get the rows to move with the sorted
Thank you so much!
<firstname.lastname@example.org> wrote in message
>I am trying to sort my speadsheet by the date. When I sort it only
> moves the information in the colum with the sort information instead of
> the whole row. How do I get the rows to move with the sorted
> Thank ...Pivot Table help! #2
I'm hoping someone can give some pointers to a pivot table newbie.
I have a bunch of data in three colums: Player, Score, and Date. I want a
pivot table that will show me the average Score for every Player, given an
arbitrary Date range that I want to be able to specify.
I'm partway there. I set up a pivot table, pull Player onto the Row Fields,
and I put Score into the Data area.
If I put Date into the Row Fields, and then group these by month, it almost
gives me what I want -- I can click on "Date" on the pivot table and I have
little boxes that I can check off if I...print envelopes from excel data
I have an excel database of addresses and I want to print off envelopes with
the addresses I have listed in this document. I have read about linking excel
with mail merge, but is there a faster method? More often I want to be able
to print off envelopes 2 or 3 at a time, so to use mail merge seems
time-consuming. Is there a way through formulas to somehow transfer for
example one row of data into word and it generate into an address format. Or
even better is there an envelope printing function in excel, as in word?
If each row of your database occupies columns A to K;
design your envelo...Clear data from pivot table
Usually when building a pivot table report I throw the data sets in
the pivot table a few times to find the best way to show data.
So I wonder - is there a way to quickly erase all the data sets so the
pivot table is again empty as just being created (so I do not have to
select each data set and remove it?
Macro or some other trick?
The closest I got to the answer was the idea to just create another
pivot table from the original data=85but it would be so much easier to
click a button and all the data is cleared from the pivot table.
Thank you as always people!
In Excel 2007 ther...Import data from Excel to Outlook
I have been trying to import contacts from an excel spreadsheet to Outlook
and my attemps have been unsuccessful. I really would appreciate any help or
tips on how to manage this operation. thanking you in advance.
Richard K Mahan Sr
"Imagination is the Father of Creativity"
With your Contacts info in columns in Excel..................
Save the workbook after giving your list a defined
name through Insert>Name>Define.
Outlook likes that.
With Outlook open go to File>Import Export>"Import...Resource Calendar Viewing
I have created the exchange account and added in the AutoAccept client. I
have also registered the mailbox. But now; How can I see the calendar and