Thread: best tool to import data from sql

hello all,

i run my reports using MS Query to access SQL database then i save as xls file and do all sorting and deleting data and so. Is there an easier way to import requested data directly by adding certain conditions example getting records between certain dates or by family names..etc.

thanks

Can't you specify your requirements in your SQL code pulling the data?

yes i can but how to put one condition with multiple names example pulling records wich contain family name "James,Davis,O'reily" only
In Creiteria Field in can select only one name.

Can't you write the SQL freehand?

In general, you'd use the IN function:

SELECT * FROM yourTable WHERE familyName IN ('James', 'Davis', 'O'Riely');

dear all,
to make it easy here is the original dqy in notepad
============
XLODBC
1
DSN=EDT_test1;Description=test;UID=sa;APP=Microsoft Office 2003;WSID=test-VSNET;DATABASE=CarData;Network=DBMSSOCN;Regional=Yes
SELECT CarTravelsFormBaseQry.CarNumber, CarTravelsFormBaseQry.StartDate, CarTravelsFormBaseQry.StartDistance, CarTravelsFormBaseQry.EndDistance, CarTravelsFormBaseQry.DriverCard, CarTravelsFormBaseQry.Destination, CarTravelsFormBaseQry.DriverName, CarTravelsFormBaseQry.DriveDistance, CarTravelsFormBaseQry.StartHour, CarTravelsFormBaseQry.EndHour FROM CarData.dbo.CarTravelsFormBaseQry CarTravelsFormBaseQry WHERE (CarTravelsFormBaseQry.StartDate>=? And CarTravelsFormBaseQry.StartDate<=?) AND (CarTravelsFormBaseQry.DriverCard Like '0%') ORDER BY CarTravelsFormBaseQry.CarNumber
Parameter Parameter
11 11
CarNumber StartDate StartDistance EndDistance DriverCard Destination DriverName DriveDistance StartHour EndHour
==================

currently the output is all trips with id card greater than zero.
my requirement is to limit output under destination values only equal to (townsquare,mall,HQ)
so how to insert these under "Destination "

thank you

Add
AND (CarTravelsFormBaseQry.Destination IN ('townsquare','mall','HQ'))
to your WHERE clause.

thank you

works fine