Results 1 to 20 of 73

Thread: Solved: Excel to access cell for cell import

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    VBAX Master
    Joined
    Jul 2006
    Location
    Belgium
    Posts
    1,285
    Location
    There are two ways you could do it.

    1. The easy one is just getting every record (which you already have) and filter them when they are present in excel (but could cost extra time when there are a lot of records).
    2. Building a selectif selection based on the where clausule. You'll have to check if you filled something in for every field. Depending on this your where section will differ.
    Then you've got also 'or' and 'and' as you define the where's (where mydate = x and person = x . where mydate = x or person = x).

    Also take a look at this site to see what kind of expressions are possible ... http://sqlcourse2.com/select2.html
    Last edited by Charlize; 11-13-2007 at 03:43 AM.

Posting Permissions

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