How to keep format when importing Excel into SQL.
Can anybody help me please?
When I import Excel file into SQL, a field that formated as 0000000000
(custom), loosing leading zeros. I tried to change data type in SQL after
importing. No luck.
I appretiate any help.
See if using IMEX=1 helps:
I tried this, but got an error: "The OLE DB provider
"Microsoft.Jet.OLEDB.4.0" has not been registered."
Thank you very much for looking into this.
"Plamen Ratchev" wr...Money Deluxe 2006 Trial to Money Deluxe Web Download.
Purchased the "full-download" Microsoft Money Deluxe 2006 version from the
trial version download. I followed all the steps to "Activate" the product
with successful conclusion.
However, the "Trial" nag screen continues to pop-up every time I sign onto
Money 2006. To add insult to injury, when I have signed onto the Support
Center, wishing to send an email to ask about this, the web-site does not
recognize my "PID" (Product ID)...because it continues to believe it is the
trail version....thusly only a serial number is listed. And, the SN is not
r...Transfer Money 98 to money 2004
I currently have Money 98 and i'am purchacing a new
computer with money 2004, how can i transfer my current
data to new computer w/ money 2004.
In microsoft.public.money, Brad Karris wrote:
>I currently have Money 98 and i'am purchacing a new
>computer with money 2004, how can i transfer my current
>data to new computer w/ money 2004.
If you have a USB flash drive on the old machine, copy your .mny
file there. Then copy the file to the new machine-- usually to your
"My Documents" folder. In Windows Explorer, double-left-click the
file on your new machine to ...Password Issue with MS Money 2003
I am not familiar with newsgroups but I hope it is a forum
to seek assistance. I am unable to reach MS support via
email from my home computer on this issue. My Money 2003
requires a net passport password to open my account in
Money that I have successfully accessed for approximately
12 months. It does not recognize my password now. I
have attempted several times with my existing password,
changed my net passport password, even uninstalled and re-
installed MS Money 2003 to gain access to my account.
Nothing has worked. Each time it states I have failed to
enter the corr...MS Money 95 data files
I hope that some one can answer this for me.
I have used MS Money 95 for years, and it works just fine for me on Windows
XP, however, I now have to reformat my hard drive, and have discovered that
I can nolonger find my original install disk. Will the latest versions of
Money still read the MS Money 95 data files. All that I have ever used the
program for is to track my investments, and am unlikely to do any different
in the future.
In microsoft.public.money, Stan Banner wrote:
>I hope that some one can answer this for me.
>I have used MS Money 95 for years, and...Auto start (and Stop) downloading from POP accounts.
My ISP rpovide me a free time to use internet conection between 2.00
amto 8.00 am.
My ISP charges me on the maount of data send / receive by me on MB
So, is any way that the MS profesionsl edition 2003 (outlook) starts on
2.01 am, starts downloding / sending the mails from POP accounts. and
stop at 7.59 am.
Is any trick available , please let me and other esteem members of this
thanks in advance.
Schedule a task (in Win), ie to start OL (I assume you will have configured
OL for polling)
Then schedule a shutdown/close of OL
"Prince" <r.r.makwana@gmai...Parsing data from one spreadsheet into another format
The data that we dump out of one machine comes in like below.
%AT_1300 Bottoms|Conductivity| (Water Out) InputRange VDC1to5
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Low 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Hi 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MinScale 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MaxScale 20.0
%AT_1300 Bottoms|Conductivity| (Water Out) EngUnits mhos
%AT_1300 Bottoms|Conductivity| (Water Out) StepResponseTime 1.0
%AT_1300 Bottoms|Conductivity| (Water Out) DigFiltTimeCnst 0.016
And I need to convert this data to this f...No Warning When Transaction Edits Are Going To Be Lost
I don't know how many times I have finished editing a transaction, and then
inadvertently clicked somewhere else, like up into the register to see a
prior example, and lost all my edits. The real problem is that there is no
notification from Money that I am about to lose all my edits, it just trashes
Sure would be nice if Money asked me if I want to save the edits before
discarding them, yes??
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" b...Drag and Drop file/directory names on Tree Control.
I am writing an application in which i have one Tree control.
Now i want that , when user drag & drop any file/folder on tree
control the file name/folder name should be add in the tree control
User may drag and drop file from desktop or may be from
I just want the path of that file/foder name nothing else.
so plz tell me will it be possible ...
Plz Help me.............
> I am writing an application in which i have one Tree control.
>Now i want that , when user drag & drop any file/folder on tree
>control the file nam...how do I connect an object from one page to a different page?
I am trying to connect an object from one page to a seperate object on a
different page. The instructions say to hold down your mouse button then
click on the point you want it connected too. My problem is that is doesn't
allow you to select the starting point of the connector, then select a
different page, then click on your end point of the connector. Please help!
try using a hyperlink.
"Pepper" <Pepper@discussions.microsoft.com> wrote in message
>I am trying to connect an object from one page to...Importing leads and workflow
We are just implementing CRM and have a couple of lead lists that we
want to import (about 5000 records). The sales force would like calls
automatically scheduled when the list is imported and would only like
50 calls scheduled per week. I know that I can assign leads based on
various criteria to the correct salesperson. However, is there any way
that I can create the phone activities and only limit to 50 per week?
Does workflow look at the salesperson work schedule at all or will each
sales person have 1000 phone calls scheduled for 3 days from when I
There isn't anything in ..."MS Money 2000" mit kostenlosem HBCI-Modul (HBCIFM99) kompatibel?
wollte mal fragen, ob das o. g. HBCI-Modul auch mit "MS Money 2000"
(also - wenn ich das richtig verstanden habe - mit der letzten deutschen
Version von "MS Money" 1999/2000 aus �sterreich/der Schweiz) kompatibel ist.
Vielen Dank schon im voraus f�r Eure Hilfe.
I wanted to ask whether the o. g. HBCI module also with "MS Money 2000"
(also - if I understood correctly that - with the last German version of
"MS Money" 1999/2000 from Austria/Switzerland) is compatib...Where is the workspace file stored?
I was given a project folder containing several dozen files. So where
is the workspace file normally located? If I don't have a workspace
file how can I cerate one? Using VC version 6. TIA
I haven't used VC6 for some time, but if I remember right you can just open
the .dsp file and it will create a .dsw file for you. It typically goes in
the same folder with the code.
"Phisherman" <email@example.com> wrote in message
>I was given a project folder containing several dozen files. So where
> is the wor...Change File Locations to Private Drive (not Folder)
I know that I can use "File Locations" in "Options" so that whenever I use
the "Open..." command in Word, it will open to a specific folder. I'm
wondering if there is a way that this can be applied not to a folder but to a
specific drive on a network.
Our company has a main public drive and has also assigned each of the Staff
their own private drive. Is there a way to access the "main page" (for lack
of a better term) of my private drive each time I use "Open..." in Word?
Right now it goes to "My Computer" or ...cant start outlook pst file to large
Hi I hope somebody may be able to help im new to outlook and now I cant start
outlook message says cannot open your default email folders pst file its too
large as I cannot open outlook I cannot delete old folders
See if this helps: http://support.microsoft.com/kb/296088
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Ray" <Ray@discussions.microsoft.com> wrote in message
news:B3B824DC-3C9B-4B1B-8EF3-61...Import from Eudora 6 to Outlook 2003
I am trying to import messages from Eudora 6 to Outlook 2003. I am receiving the error message "The mail folder could not be opened. If another application is using this file, please close and try again.
No other applications are running
Thanks for any help
see article 257354 of the microsoft knowledge base on
"Outlook Cannot Import Eudora Messages When Eudora Mail Is
Stored in a Non-Default Location"
>I am trying to import messages from Eudora 6 to Outlook
2003. I am receiving the error message ...2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ?
We have a small store and would like to setup a second register as a backup,
temporary addition ( during rush hours)
Since we are a small show i do not need to have a separate register reports.
Can two registers ring up all sales together as one ?
How can i set this up ?
No, you can't do that.
You might be able to use the Register Analysis report available in SO
Manager Utilities/Crystal Reports to get something close to a single Z
Tiber Creek Consulting
firstname.lastname@example.org...Unexpected error message on closing an Excel file
Suddenly I am getting the following message when I try to close a workbook:
"Your formula contains an invalid external reference to a worksheet.
Verify that the path, workbook, and range name or cell reference are
correct, and try again"
The mysterious thing is that it does not happen consistently and that, after
I click OK after the above message, I can still save the file.
What might be the cause of this error message and can the "invalid
reference" be tracked down using one of the utility add-ins such as J.
If it only happens when you close ...Outlook freezes after sending one email after upgrading 4.0
We just upgraded from 3.0 to 4.0 this weekend. All client machines have had
the desktop client upgraded and 2 have the same issue. One is XP with Outlook
2003 and the other is Vista with Outlook 2007. Open opens and the CRM addin
initializes correctly. As soon as you compose and send an email, Outlook
locks up and you have to kill the process in task manager to close Outlook.
I've had the same problem and have tried all I can think of...how did you fix
> We just upgraded from 3.0 to 4.0 this weekend. All client machines have...outputting values to a range from one formula
I wish to generate a table automatically by means of a single
formula that applies an iteration on a starting given value with
a given step, and the computed values are posted/entered
automtically into cells from a given cell onwards, say below
it, until the computed value reaches a certain given limt.
This is somehow the inverse of INDIRECT or of OFFSET. These
can pull values from a variable addresses of cells. What I need
is to push values into a variable addresses of cells.
Can anyone help me on that??
Why don't the deposit transactions that originate in Receivables
Management indicate a cleared amount or cleared date in the Bank
Transactions SmartList even though they've been cleared thru Bank Rec?
MCP-GP, MCT, MVP
East Coast Dynamics
Mine shows up OK. I just tried it, no problems. What version/build
are you using?
9.0, build 0301 Leslie.
MCP-GP, MCT, MVP
East Coast Dynamics
Thank you ...Trying to read XML file into dataset
Developing a web site in VS2005, SP1, VB, .NET 2.0, ASP.NET 2.0 on XP Pro,
I eventually want to use a gridview table to view xml data, but right now i
can't seem to get my xml data into a dataset so that i can use it.
I have an XML file and can open it in IE. There is no XSD or XSL file to go
I can't seem to get the XML data into a dataset. I tried using the
following code, but it just does nothing. It doesn't give an error. It
just executes the code and does nothing.
Dim dataSet As DataSet = New DataSet
dataSet.ReadXml("...Outlook Express 6 w/multiple accounts
I have three accounts set up in Outlook Express 6. Two of
them work fine, but when I reply to or forward a message
sent to the third address, it uses the second address in
the "from" line, so I have to change it manually. This
does not happen with the other two. How do I fix this?
...Linking information form one worksheet to another
Hi, i have a big problem
i want to create a link between some columns in two seperate worksheets, so
that when i type a name on the master sheet it would give me the required
information.Dont know if i explained this right, lets say on the master sheet
i have columns : Name,Sex and Height on columns A,D and BH respectively i
want that if i type a person's name in worksheet 2 it should give me the
results on columns A,C,F in that worksheet. Please help i need it asap for my
One way ..
Assuming your "master" sheet is named: Master, with data in row1 down
In Shee...Exchange 2007 across account search
Does Exchange 2007 has an option to search all users mail for keywords?
That all SBS workgroup users can search for messages to/from all other
Is there any advanced indexing system to speed up search results?
On Tue, 26 Jan 2010 14:22:12 +0200, "Ronald" <email@example.com> wrote:
>Does Exchange 2007 has an option to search all users mail for keywords?
>That all SBS workgroup users can search for messages to/from all other
>Is there any advanced indexing system to speed up search results?
Bunch of ...