regional conversion of excel to .csv
I have a database that with US regional settings will export to an excel
spreadsheet in .CSV format multiple column headings.
The spreadsheet will have 3 column headings of | Location | Device |
But when I switch to a European regional setting such as Germany, the export
in .CSV format converts the data into a single column.
The spreadsheet will ahve 1 column displayed with | Location,Device,Quantity |
Is there a setting or a way to change this conversion from a single column
to multiple columns to mirror the US regional settings. I can not upload the
resulting .CS...Query Source for Text Box
I'm trying to set the value of a text cell as the sum of the values in one
table with conditions based on returned values from linked tables:
=DSum("V","T1","(SELECT Sum(Value) AS V FROM CostTypeLook INNER JOIN (CCLook
INNER JOIN CostBase ON (CCLook.[Cost Centre] = CostBase.[Cost Centre]) AND
(CCLook.Co = CostBase.Co)) ON (CostTypeLook.Account = CostBase.Account) AND
(CostTypeLook.Co = CostBase.Co) WHERE CostTypeLook.[Cost Type]=10 AND
CCLook.Flag='NP') AS T1")
But of course it isn't working which is why I'm having to ask...Windows Mail Message rules
I have a small problem - mainly because I only have three News message rules
The Apply Now function appears to be broken - and until I can get it working
again, I can't really check to see whether the rules themselves work
WinMail in a fully updated Vista (with fully updated Office 2007 in the mix
as well, just in case it makes a difference)
Whichever rule I pick, and whichever account or newsgroup I try and apply it
to, Apply now starts to work - and then I get a "One or more of your rules
could not be applied" message - The rules used to work fine,...Transfer Groupwise files over to Outlook 2002
All apologies if the answer to the following question is posted to a
FAQ page-I have limited acess on this system. What is the best way to
save all of my files and folders in Groupwise 5.5 over to MS Outlook
Thank you in advance.
Navigate to this page -- http://www.slipstick.com/config/ -- and then hover
over the link in the left-hand frame that says "Converting to Outlook".
There you will find a list of articles that will help you figure out how to
convert various types of Groupwise data to Outlook.
MVP - Outlook
*** Messages sent...Extract dd and mm from text and put that plus current yy in another
I've got a workbook which comes from someone else and it's got a cell
in it from which I want to get the above. The format of the cell
varies. It could be texttexttext 17Feb09, texttexttext 17th Feb,
texttexttext 17 February 09, texttexttext 17th February 2009, etc (but
never Feb 17 - I'm in UK not US!)
Try Text to Columns (in the Data menu). It should convert most every date
"robzrob" <email@example.com> wrote in message
> I've got a workboo...odbc error
I'm trying to export some data from OmniForm into Excel.
There are 25 fields - 20 are short responses. 5 are
I get an ODBC error:
[Microsoft][ODBC MS Excel Driver] String data, right
it only imports the first record (which has 2 blank
fields at the end?/) then returns the error.
If I remove the last 5 comment fields - all records
I have MDAC 2.8 on my XP - using Excel 2002.
I'm in a crunch to get this data... any ideas???
thanks in Advance! Cindy
...How can I get my text to arc in Visio?
I have a circular pie chart. I want my text in various places on the outside
of the ciruclar pie chart to arc with the circle. I know how to add text
boxes, but they don't arc--they are flat across
the usual way (since visio doesn't support it) is to copy it from something
"michobrien" <firstname.lastname@example.org> wrote in message
>I have a circular pie chart. I want my text in various places on the
> of the ciruclar pie chart to arc with the circle. I k...saving excel files #2
Hi all ,
I am having a strange prob in excel
whenever i save an excel file, it asks for extension (*.xls)
there is something wrong with the settings this i know
like when u save a new book on desktop it will save it as vikram.xl
instead of vikram
what is the way out
i dont want this file extension along with the nam
Vnagpal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=26734
You can either hide the ext...Windows XP, Excel 2000: ODBC driver for Visual FoxPro tables
I have some made some Excel applications which are querying data from
dbf-based 3rd-party program, using ODBC driver for Visual FoxPro
tables(Data.GetExternalData....). Applications are made on Win98 computer,
they are situated on shared network resource, and are accessed from
different computers - until lately with Win98 as OS in general.
There were no problems until we replaced some computers with new ones - with
Windows XP installed. For first such computer I downloaded a driver from
Microsoft (~ year ago), and it works. But meanwhile I had to replace a hard
disk in my own computer, an...recovering chart source data from deleted files
Hi - I have a file with quite a few charts that were created using
source data from another file. That other file has since been deleted
by incompetent boss, who now wants me to compare these charts with
newer data. Is there anyway I can recover the lost source data using
only the charts? Many thanks for all help.
This MS Knowledge Base article has a marco to extract data from a chart:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
...Firefox - new windows, lag time, about 20 seconds before the new window shows
Firefox - new windows, lag time, about 20 seconds before the new
window shows - any ideas?
This is a recent phenomenon - whenever I use Firefox and try to use
CNTL N or open new window (or if a link takes me to a new window),
there is sudden lag time of about 15-20 seconds before it appears.
Not sure why. Going to post in the firefox forum as well. Any ideas?
On Tue, 16 Mar 2010), daviddschool <email@example.com> wrote:
>Firefox - new windows, lag time, about 20 seconds before the new
>window shows - any ideas?
>This is a recent phenomenon - whenever I...fill in a text box
How do I fill in a text box with TekstAandeel being the name of the
textbox in my userform. This is wat I have. In the beginning It's set
at "" (empty) but I want to fill it in witch access stuff.
Set A = DB.OpenRecordset("SELECT Aandeel FROM DDM Where Ticker='"
& TekstTicker.Text & "'", dbOpenSnapshot)
TekstAandeel.Value = ???????
...import data from text/word/excel...
Is there a way to import old data into Money2003 from a
text, Word (table or text), Excel, or Access file? I can
put the data I have into those formats but Money wants a
QIF, Quicken, etc format to import data. Any suggestions?
"kkg" <firstname.lastname@example.org> wrote in message
> Is there a way to import old data into Money2003 from a
> text, Word (table or text), Excel, or Access file? I can
> put the data I have into those formats but Money wants a
>...Query to text file cuts my leading zeros off.
Hello, this is my third attempt to post this question.
I have a query that has a value of "012810" in one of the fields.
When I run the query it shows up as 012810.
When I export to excell it shows up as 012810.
When I export to text file it always cuts off the zero and I get 12810.
If I change the value to say 212810 and then export to a text file it works
fine and returns 212810.
Why is the zero being chopped off during a text file export?
Its being treated as a numeric value.
Is this column defined as numeric or text?
It needs to be defin...Attached MSG files change when saved
I have this scenario- I have a .MSG email, and attached is a .JPG and
another .MSG. I want to save these attachments and generate a hash value from
the file binary. Usually not a problem, but I have encountered some strange
behavior when saving attached MSGs.
No matter how many times I save the .JPG file, the resulting file's binary
is always the same, which is great. However when I save the .MSG file the
binary is slightly different every time. Is there a way through outlook,
outlook API, or any other means, to save an attached MSG as the same binary
file that it was whe...copy and pasting one file into several different folders
Is is possible to copy and paste one file into several different folders at
the same time?
Not literally. You can copy one file and then choose different folders, one
at a time, and paste the copy into them individually. But at least you don't
have to go back to the original and start all over with "Copy" each time.
> Is is possible to copy and paste one file into several different folders at
> the same time?
You can use macros or write a small batch file to automate the copying.
"jame...OPOS keyboard (driver wanted?)
I make a small line of keyboards for PC's that connect via PS/2, RS-232
or USB. I have a customer asking me if I have an OPOS driver and I'm
not sure what that entails. I am looking for someone that can write
one -- once I figure out what it is ;-) Can someone point me in the
right direction? I understand that such a driver allows you to (among
other things) set the focus of the key data to windows other than the
topmost one. Also, is there some kind of hardware requirement for OPOS
or OLE for Retail Point Of Sale? I do have some products that are
Does an OP...Unexpected Text Insertion
When forwarding or replying to a message using HTML in Outlook 2003,
the first key to be depressed when attempting to edit the text of the
original message, automatically inserts my name in color. I am forced
to select the text, delete it and continue with the editing.
Here's the strange part, if I open the message, select reply, click the
html box, switch to plain text, then switch back to html it prevents
the text from insertion.
Thanks for the help,
Try going to Tools->Options->Email Options and clear the "Mark my comments
with" and/or prefix each line wit...How to remove the /dde from Windows Explorer File Open on Install
I have an MDI app that I would like to open a file on a double click in
Windows Explorer. Unfortunately the Explorer File Type (Tools>Folder
Options... File Types tab) is set so that the command invokes dde. Ie. The
"open" option under the "Advanced" button is C:\Path...\App.exe /dde and the
DDE message is [open("%1")].
This never seems to work as my app never sees the dde message and the
initialization of m_pCmdInfo via:
m_pCmdInfo = (CCommandLineInfo*)(UINT_PTR)m_nCmdShow;
sets the pointer to one and the app fails on exit. This is referred as a
kn...numbers in text box
I am recieve data from a scale in text box. It has number and other carater.
How I could take only number in text box. I am work with 2008.
thanks for your help
"Roberto Londono" <RobertoLondono@discussions.microsoft.com> wrote in
>I am recieve data from a scale in text box. It has number and other
> How I could take only number in text box. I am work with 2008.
> thanks for your help
It depends on how you receive your data, but I did this for a similar
situation. I...Size (mb) of sheets in file
Is there any way of finding out the mb size of individual sheets within a
workbook. I can only view the size of the file as a whole by going to File
and then Properties and General
No better than an estimate...
Make a copy of your workbook.
open that copy
delete a worksheet
save that copy
compare the size of the original workbook with that copy.
Repeat as necessary.
> Is there any way of finding out the mb size of individual sheets within a
> workbook. I can only view the size of the file as a whole by going to File
> and then Properties...Import a pst file into out 2003
I put all my files 1999 to 2003 into a pst folder. copyed
to a cd.
I cannot retrieve them now i have tried all... It says
that it is not a pst file, (impossible)... i did copy
into my current pc.
PLEASE HELP i am desperate... 4 yrs work..
Just created a new pst.. and renemed the old one (650MB)
with the new name...
this was the error message when i tried to access..
"The set of folders could not be open. the server is not
let me add that I am accessing a pst created in a non
Copy all .pst files from the CD to your hard drive and th...excel budget file locks
Does ayone have issues with the excel budget import wizard locking up the
excel file after completion ? It is a nuissance for many of my clients and we
have not resolved the issue. It seems to happen in terminal server sessions.
Yes, we have the same issue. We have to initiate an Excel session from
within GP (easiest way is to export something from SmartLists) and close the
budget file to unlock it. This did not happen when we were running v7.5. It
started after upgrading to v9.0. We run GP over Citrix.
"Brian Connell" wrote..."..." in file name path
I remember there was one API function that would make long paths short
by inserting "..." in path:
but I can't remember func name?
Try PathCompactPath(Ex) shell functions.
"Petar Popara" <email@example.com> wrote in message
> I remember there was one API function that would make long paths short
> by inserting "..." in path:
> c:\program files\...\my.xml
> but I can't remember func name?
Try to avoid ever doing thi...I check "windows in task bar", after restarting, it is no longer c
In Excel if I check "windows in task bar", (Tools, Opions, View Tab) after I
have restarted the machine this option is now unchecked. I have unchecked
"Group Similar Task Bar Buttons" in my Task Bar Properties
What version of excel are you running?
There's a bug in xl2k that shows up if you're working with shared workbooks.
If you're not using xl2k and shared workbooks, it sounds like you don't have
permission to save this setting in your windows registry.
I'd talk to my IT folks to find out if they can fix it.
Saved from a previous post....