How to import DATA from SQL2K to Access?
I am using get external data, import, ODBC type and it's error out saying I
cannot use ODBC to import/export data.
I would appreciate if someone please show me the better way of importing
data from sql.
1 - From SQL Server, use DTS to copy the data from the SQL Server table to
the Access table.
2 - From Access, link your SQL Server table through ODBC and then use an
append query to copy the data from the linked SQL Server table to your
M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Ac...How do I change data in one cell so other copies& vice versa
i have two cells that i want linked.....i know how to link one cell to
another but my question is this how do i link cells so that when data is
changed in either cell BOTH of the cells change.....example enter data in
a1 to make b1 change....how do i make it so i can enter data in b1 to make
a1 change....so they both can change each other.. thanx
not possible without using VBA 8an event procedure)
> i have two cells that i want linked.....i know how to link one cell
> another but my question is this how do i link...Data file not closed properly?
Frequently, although not every day, when I boot up and open Outlook 2003
(SP1), I get a brief message which reads "The data file "MAIN" was not
closed properly". It then runs a quick check, a progress bar zips by, and
then my "Main" Outlook .pst file opens.
The thing is, I close Outlook the same way every night before shutting down,
and cannot figure out why it thinks there's a problem. There hasn't been a
problem with my data.
BTW, this behavior began - albeit intermittently - after installing Windows
XP Pro SP2. Could that have something to do...averaging data in multiple columns
I'm looking for a formula to lookup criteria in column A and average the
results in columns B, C, D, E, etc.
For example I would like to know the average of how many "CATS" have been
in a given year and I will be adding addtional months as time progresses and
do not want to have to adjust my range or formula each time a new months
worth of data is added. For example.
column A column B column C column D column E
DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 ...Data control in CRM for business units
We currently have a large scale CRM deployment in the offing, but we
need to be prepared for how data, fields, etc can be segregated between
Business Units - if indeed this is possible - although I did read
somewhere previously that this was a possible way of deployment -
clearly, there are default data fields, views, data, etc were
site-wide, but there were also business-unit wide ones too that could
be created and controlled???
We have a few Business Units that will share the single CRM
deployment/installation. The ethos was that those in Business Unit 'A'
had full contro...Changing mulitple fields visibility from a single data entry
I want to use one control to determine which others within my form are visible
i.e. In a text box labelled 'How Many' if 1 is entered then the text box
labelled 'one' is visible and box's labelled two, three and four are
invisible, if 2 is entered then 'one' and two' are visible and so on.
Any help would be appreciated.
You've described a "how" ... how you are trying to do something. If you'll
describe the "why" and "what" (what will having this allow you to
accomplish?), the newsgroup readers may be able to...Data Selection
I need a little help
Picture my screen
I have 16 teams and about 12 to 15 people per team
Cell C1 TO C100 Contains Various Team Names
Cell D1 to D200 Contains peoples Names
In Cell A1 Contains "Team Name"
in Cell A2 i want to select a person from the list i have created in C1 & C2
but it needs to filter out only the people that play for that team selected
Anyone Got any idea's
Thanking so much in advance
...unable to enter data on form. help?
I have created a form using a relationship between two tables. This was to be
a data entry form but when I try to enter data nothing happens. The cursor
moves to the first field but typing doesn't result in data appearing on the
screen. I could do with some help
It sounds like you have based the form on a non-updatable query.
For a list of why this might be so, see:
Why is my query read-only?
There are other possible explanations, e.g.:
- you set the form's AllowEdits property to No
- you set the form's Recordset Type property to...Change Pie Chart segment color based on value in source data
I am creating a training matrix which shows current status of training
progress. I want the pie chart to always display three equal segments. I want
each segment color to change based on the data input in the source data.
Hopefully this is an adequate definition of what I am trying to do?
Assuming you have 3 possible colours for each segment you need to create
a pie chart based on 9 cells. The content of the cells is determined by
formula and will either display a 1 or 0.
Training data in range B2:B4 with values 1, 2 or 3 to indicate level.
Formula in cells F1:F9
I=92ve set up an OLEDB link between two excel workbooks. When I bring
the data across the first 7 columns convert the numerical data to text
whilst the following columns are correctly formatted as numbers. I=92ve
gone back to the source spreadsheet and everything is correctly
formatted as numbers. Why does OLEDB do this ? I cannot find out
how to get the data coming across in the correct format ?
...data refresh cell reference
I have a workbook that has several different spreadsheets, each with
different query that gets refreshed through ODBC when the workbook i
used. Each query requires that a date range be entered.
It will always be the case that the same date range will be entered fo
each of the 6 queries.
Question: is it possible to have the query reference specific cells i
the workbook, so that my users don't have to enter the same "To" an
"From" dates six different times? In Access I'm able to referenc
values on forms, but the same logic doesn't seem to apply with ...Sample data wizard not starting up 02-26-07
I have successfully installed CRM 3.0 on a W2003 SP1 box with SQL2000 SP4.
When I try to run the sample data wizard nothing happens but this line is
added to the logfile:
Sample Data Wizard started at 2/25/2007 3:02:41 PM
Error occurred while trying to retrieve the users from the Active Directory
Domain - 2/25/2007 3:02:48 PM
The type initializer for
"Microsoft.Crm.Tools.SampleDataWizard.ChooseUserForm" threw an exception. -
2/25/2007 3:02:48 PM
Sample Data Wizard completed at - 2/25/2007 3:02:48 PM
Does anybody have any idea what might cause this, the wizard has wor...moving data from one db to another
I have a pretty general question about what might be the best way to handle
this. I need to write a watcher program to export flagged rows in an MSSQL
2005 db out to a MySQL db. After each row is copied, I need to reset the
flag in the source. I'm wondering if anyone could tell me what the best
process for this would be. Looping through all the rows in the source one at
a time and then posting them one at a time seems like the wrong way to go.
There's a lot of vb.net that I don't know so I'm thinking there might be a
better, simpler way to do this. Initially there...Can I use data from different worksheets to create a chart
I am running Excel 2000. I have 3 worksheets from different schools. I want
to compare ratings from each of the schools in one chart. Can I do that and,
if so, how. Thanks
Yes you can build a single chart that plots data from 3 different
worksheets. You haven't said what type of chart, so I will walk you through
an XY (Scatter) chart. Let me know if you need help with another chart type.
Step 1 - Create new worksheet where you will place embedded chart. Name your
new worksheet Charts
Step 2 - In your new Charts sheet, from the top menu select Insert > Chart
to start Excel...updating data on tab pages
I have a form with a tab control with multiple pages. When a value is
selected on a control on one of the pages, several related values are filled
in on other pages. I've tried this with a macro that sets a value based on a
dlookup, and I've also done it with an update query based on the same dlookup
amount. Either way works until I click onto another page on the tab control.
When I click to one of the other pages it says "This record has been changed
by another user etc." and gives the choices to drop the changes, save the
I tried adding a saverecord command...Data validation for Multiple columns
I am creating a spreadsheet which will have data entry from different
I want to give the validation in such a way that a combination of
values in 2 columns do not occur more than once.
in above example the combination 2 and a is recurring. it should be
restricted by validation while entering the data itself.
can anybody please help
sorry for bothering you all
but i got a solution on other group
here is link for others reference
http://groups-beta.google.com/group/microsoft.public.excel.programming...Excel Drop Down box or check box data to Excel Database
I desperately need help with this! I have an Excel form which I have
included check boxes, drop down boxes and Yes no. How do I incorporate the
data into the Excel database?
Maybe you could use some of the techniques that Debra Dalgleish shows at:
> I desperately need help with this! I have an Excel form which I have
> included check boxes, drop down boxes and Yes no. How do I incorporate the
> data into the Excel database?
You can send me the workbook and I may be able to assist.
...Can I include the timezone in the savedate field in MS-Word?
Can I include the timezone in the savedate field in MS-Word?
For example, i'd like the result of the savedate field to be:
mm/dd/yyyy 01:00 PM EST
Either simply type EST after the field or use a switch \@ "MM/dd/yyyy hh:mm
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>...saving data in excel from word doc.
I have address labels in word doc. and I want to save it in excel. But it
should be each address in differant column. How should I do that?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
Microsoft MVP Excel
"Evette" <Evette@discussions.microsoft.com&g...Auto updating pivot tables using external XML data
I'm new to Excel and have been playing with importing XML data and
pivot tables recently.
My goal is this: I have bunch of XML files in a directory. I'd like to
generate pivot tables and "visualize" the data in them. Once my excel
sheet looks good, I'd like to publish it as an HTML file so everyone
else can view it using Internet Explorer.
In fact, I already did all this. Here is the tough part though: These
XML files get updated from time to time. And when I open the Internet
Explorer, I want to see those latest data in XMLs.
In my case, Excel publishes the ...How import data???????
Hi my name is Edson, and I need impor data to new entity create for
my, named participante.
The infomation is in SQL SERVER.
I try with DMP but the CDF haven=B4t my entity..
How can I make it???
If I need some software when can I download???
...Rebuild of Data Base
Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
I had an error/corruption of my entourage data base. I used the wizard to validate the data base, which after was completed was determined to be OK. I then performed a rebuild of the data base, which also completed with out any issues. After the two actions were completed I have found that I now have two Main Identity folders labeled as follows: <br><br>Main Identity <br>
Main Identity (Backed up 2009-12-03 17.37) <br><br>Two Questions: <br>
1 Do i need t...linking data #2
I know how to copy data from one Excel file and do a Paste Special, Paste as
Link onto another file. That works fine but the updated data flows in one
way only. Is there a way of linking two Excel files so that you have the
same data on each one, but they are linked so that updating data in one file
will automatically be shown in the second file, and this will happen no
matter which of the files is updated? I don't see anything in Excel that
would allow this.
You can do the tow way flow, but it is a BAD idea.
Better is to use one workbook, with one worksheet as your...How does money get its data?
I bank with Navy Federal Credit Union and I am *trying* to adapt to MS Money
plus (demo right now) from scattered use of Quicken. I'd like to learn how
money gets my bank information so I can make an educated call/complaint to
the credit unions technical group about the data I am getting.
I am currently testing two mny files, one automated and one manual. Today
with NFCU, when I do their recommended manual method by signing on to the
website, selecting a date period then importing a QIF file, all the
transactions show up as "POS Debit Visa - Acct#last4" and no other
in...Creating checkboxes that change data
Can anyone help / make suggestions in achieving the following:
I am trying to create an invoice that summarises the total of the
products at the bottom of the spreadsheet.
What I want to achieve is some way of having various products in a row
which a user can select via some sort of check box (giving the product
a boolean value).
Each product would have a price value attached to it and when it is
selected the price should be added to the total.
This would therefore allow the user to select various products and the
total would be calculated accordingly.
This seems relativel...