Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2015
    Posts
    1

    Unanswered: Conditional Export Access data to Excel

    Hi,

    Is there a way to export Access table data to Excel using some sort of WHERE IF statement. I only want the Access table row data from a column called PRIZE "IF" another data from a table column called PARCEL matches a PARCEL data in the Excel spreadsheet.

    Thanks for any pointers,
    cov

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Use a query to extract the data required
    then export that to a spreadsheet
    or
    import it into a spreadshwet
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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