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

    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
    Location
    Aberdeen, Scotland
    Posts
    1,067
    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
    Location
    The Hague, Netherlands
    Posts
    95
    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:

    http://www.functionx.com/access/
    http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

    gl

Posting Permissions

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