Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
msquery
a simple stupid question....
does msquery add the data to what is already there or does it replce the data? (query is linked to access db) any links to explanations and examples of msquery appreciated. thAnk you! patti |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
msquery
hi,
it is to my understanding that you can do it either way. right click the MSQ, then click data range properties. at the bottom you can opt to insert rows for new data or overwrite existing data. not sure which is best. i always overwrite. links.... http://office.microsoft.com/en-us/ex...747511033.aspx http://office.microsoft.com/en-us/ex...CH100648471033 regards FSt1 "patti" wrote: a simple stupid question.... does msquery add the data to what is already there or does it replce the data? (query is linked to access db) any links to explanations and examples of msquery appreciated. thAnk you! patti |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
msquery
hi.
since you asked, i went looking. found another. http://support.microsoft.com/kb/136699 about joins. regards FSt1 "FSt1" wrote: hi, it is to my understanding that you can do it either way. right click the MSQ, then click data range properties. at the bottom you can opt to insert rows for new data or overwrite existing data. not sure which is best. i always overwrite. links.... http://office.microsoft.com/en-us/ex...747511033.aspx http://office.microsoft.com/en-us/ex...CH100648471033 regards FSt1 "patti" wrote: a simple stupid question.... does msquery add the data to what is already there or does it replce the data? (query is linked to access db) any links to explanations and examples of msquery appreciated. thAnk you! patti |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
msquery
thanks for the speedy reply. i've never used msquery but have been given a
spreadsheet to work over. how do i right-click on the msq? as for adding the data, i mean adding the retrieved cell contents to current cell contents. If A1 was 4 and the incoming A1 was 10, i'd want A1 to result in 14. i mainly use access so i understand queries pretty well - just don't get what's happening w/ data in excel. patti "FSt1" wrote: hi. since you asked, i went looking. found another. http://support.microsoft.com/kb/136699 about joins. regards FSt1 "FSt1" wrote: hi, it is to my understanding that you can do it either way. right click the MSQ, then click data range properties. at the bottom you can opt to insert rows for new data or overwrite existing data. not sure which is best. i always overwrite. links.... http://office.microsoft.com/en-us/ex...747511033.aspx http://office.microsoft.com/en-us/ex...CH100648471033 regards FSt1 "patti" wrote: a simple stupid question.... does msquery add the data to what is already there or does it replce the data? (query is linked to access db) any links to explanations and examples of msquery appreciated. thAnk you! patti |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
msquery
hi.
You will find that MSQ work pretty much like access once you get into the MSQ wizzard and the MSQ dialog. you add query criteria the same way. but as to right clicking. somewhere inside the MSQ data, right click. if the MSQ returns data that is 10 columns wide and 500 rows long. right click on D5. think of it as a table. MSQ don't work that way. it retrieves data that is in your access database. that's it. but unlike access, you can do some math by putting formulas along side the MSQ and i have had them about 4 columns. In access, you do the math in the header. you can also have formula at the bottom for totals or whatever but you cannot add columns and put formula in the middle of the MSQ. The MSQ is like a named range or table and all cells(columns and rows) the MSQ returns is reserved for the MSQ. when your right click the MSQ, at the bottom check "fill down formulas in columns adjacent to data". MSQ will add formulas for new data (and remove if the data shrinks which it seldom does). good luck. it's fun. regards FSt1 "patti" wrote: thanks for the speedy reply. i've never used msquery but have been given a spreadsheet to work over. how do i right-click on the msq? as for adding the data, i mean adding the retrieved cell contents to current cell contents. If A1 was 4 and the incoming A1 was 10, i'd want A1 to result in 14. i mainly use access so i understand queries pretty well - just don't get what's happening w/ data in excel. patti "FSt1" wrote: hi. since you asked, i went looking. found another. http://support.microsoft.com/kb/136699 about joins. regards FSt1 "FSt1" wrote: hi, it is to my understanding that you can do it either way. right click the MSQ, then click data range properties. at the bottom you can opt to insert rows for new data or overwrite existing data. not sure which is best. i always overwrite. links.... http://office.microsoft.com/en-us/ex...747511033.aspx http://office.microsoft.com/en-us/ex...CH100648471033 regards FSt1 "patti" wrote: a simple stupid question.... does msquery add the data to what is already there or does it replce the data? (query is linked to access db) any links to explanations and examples of msquery appreciated. thAnk you! patti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msquery | Excel Discussion (Misc queries) | |||
MSQuery | Excel Worksheet Functions | |||
Msquery and join | Excel Discussion (Misc queries) | |||
MSQuery problems | Excel Discussion (Misc queries) | |||
MsQuery Documentation | Excel Discussion (Misc queries) |