Questions & Answers for: Microsoft Office changing table

Running SQL queries on Excel Hi, Is there a way to run sql queries on Excel 2007? For instance I would like to build a table and select certain rows using sql script. Thanks, D. Another way to do it ...

Excel Pivot view When we create a Pivot chart using Pivot Wizard it creats a OLAP query which contains the path for the table data. If we move the table data into some other place then the pivot chart

update record with two table update a record in one table from another table base on one same field have an Access 2003 database that appears to be very corrupt. I was having a problem and did a ...

Conversion of nemeric value I would like to know whether I can convert the numeric value into charecter value If you just want to change the format to text in a query, you can use the Str function in ...

Microsoft Access 2003 I have been trying to solve the following problem but could not figure how to do it: i have a table containing about 200 records -having the employees identification number,the ...

Access 2003 subform won't scroll I have an access 2003 database with 3 subforms with scroll bars that won't scroll beyond record 82 of 102 available. If you could see what you were doing adding ...

...table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming ...

changing the calculation option to "manual' and pressing the F9 key. Is there anything that I can do to improve (speed up) the calculation time? The DSUM function is very useful, but it does use a lot

how to ruled a table in microsoft word 2007? Please follow the following instructions Open the word document in which you want the table, navigate to the location whee we need to table Click on the ...

update a record and save it in two or more tables. First, make sure that the tables that you are using have some sort of Primary Key so that the correct records can be linked. Next, choose 'Tools' ...