Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Using excel with microsoft query instead of access

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •