Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use of SQL Querry in MS-Excel
- Thread starter dvcf1n
- Start date
- Thread starter
- #3
An alternate,....
from the menu choose Data>Get eternal data>newdatabase query>...then select Excel files from the list, follow the wizard from there....
after your data is returned to excel ....you can right click in the data area of the sheet to edit, set properties, such as auto fill fomulas, refresh on open etc...
if you edit...using the Ms query option, you can set critera
from the "view" menu in the msquery editor, then enter a criteria for any field in the database/excel sheet
from the menu choose Data>Get eternal data>newdatabase query>...then select Excel files from the list, follow the wizard from there....
after your data is returned to excel ....you can right click in the data area of the sheet to edit, set properties, such as auto fill fomulas, refresh on open etc...
if you edit...using the Ms query option, you can set critera
from the "view" menu in the msquery editor, then enter a criteria for any field in the database/excel sheet
- Status