Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Unanswered: Manipulating Excel sheets within Access

    Hi, I need to open and do some processing with an Excel file, like check for some values, a couple of if then statements, nothing too coplex, so I wonder what is the simplest way to do it. I am importing some excel files in a database (Access) and i would like to have more control on the various fields (cells) than I get by using the ImportExcel command.

  2. #2
    Join Date
    Jan 2004
    Aberdeen, Scotland
    Hi Backstage i take it you are only wantingsome of the data from your spreadsheet into your db tables, the simplest way to do this in my humble opinion is to link in your excel file then run a query on it to be able to produce the results required, this could then be appended to your query

  3. #3
    Join Date
    Feb 2005
    The Hague, Netherlands
    As I understand (I'm just starting in Access too :P) you can make modules in VBA where you can do relatively easy If-then statements and things like that. Also the checking for some values is rather simple in Access. Maybe I can save you some work if you need it, found lots of tutorials, but these too looked best:


Posting Permissions

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