MSquery from SQL, ignore record?

[mjfmn]

I am trying to figure out MSquery to get data from a new sql database in our system. When I bring in data from the selected table, I want it to ignore any records where last_user=Convert and tran_type=Balance. I can't quite figure out how to get it to look at both of these instead of each one individually. Currently I'm using the wizard in Excel 2007, but I can start working without it as well. Any help is appreciated - thank you!
Mike

 

[mjfmn]

I'll bump this if you don't mind - anybody? I can't just bring all the data in and have the user delete out the records with this info, they don't have much of a "comfort level" to make changes like that. Thanks again!
Mike

 

[xenou]

I'm not very familiar with the "Access" icon in the data tab - I know you see Access tables as options to import. Possibly if you create an Access query you would see it too, and would be able to import the query results (in this case, you'd create the query in Access first, per your specs).

If the Access button in Excel 2007 only lets you bring in tables, the other options is to go to the "from other sources" button and bring in the data as part of an MSQuery data source. There's actually many ways to go about this but I found what looks like a very good, easy to follow tutorial:
http://www.java2s.com/Tutorial/Micr.../0260__Collaboration/CreateaDatabaseQuery.htm

Give it a shot and see if you succeed. If not, post back with your further woes. You'd probably also find more hits googling "excel 2007 data query" and/or other keywords like "access", "create", "external data", "msquery", "data connections", "query table", "querytable" (sorry to be so precise --> now you know more about how I think when googling).

ξ

 

[mjfmn]

I'll give that a try, thank you!
Mike