Using excel with microsoft query instead of access

[HERMIT]

Hi. In the past, when I have had large data sets in excel, I have been importing it into access in order to find duplicates, find unmatched and so on. However, of late I have found that microsoft query on excel does pretty much the same sort of thing.

If anyone has any experience of using microsoft query, could you please give me a general overview of how much stuff you can do on it without having to use access. Also, when would you use the Data base functions in excel compared to the normal functions for sum, average etc? Do the database functions do things quicker? I haven't noticed much of a difference but then again my datasets aren't THAT big.

Cheers.

[lenze]

You can use MS query to make your own rational database. See this site for a tutorial

http://tushar-mehta.com/index.html?h...cel/intro.html

[Jack in the UK]

OK querys are normally ODBC and on networds

so depends all on the network and so on.

Access is better at large data bases and they like nice, i never use access as its not excel for me i only use excel and refuse to use an other office product. but will do as you ask.

check the help files and decide if d functions are for you, its poss to use say sum and getthe right result as is dsum, d functions are complex in comparison an understanding is required but thats what databases are all about this row that column the make of car that coulur thich is call excel and so on answer is $100 they ask for the table and ros and then what you want.

try them they are so powerful and fast its amasing, take a bit to get used to until you undestand their ways.

I use them

dsum
dcount
dcounta
dmax
dmin

thats about it dget is used a ot check these out see if they are for you

remenber if you are trying a function and get stuck post a question we will always help you out...