Search results

  1. E

    Macro function to convert excel to access and replaces old data with new one

    i need help in creating a macro that would automatically convert an excel spreadsheet into an access database.. each month, i basically receive a spreadsheet that has around 15 columns in it. the columns are the same each month: employee id, employee name, account id, account name, commission...
  2. E

    Vlookup equivalent in Access????

    Hi all, I am currently working on an Access project. I have 2 tables: Table 1 has 10 fields: Account ID, Employee ID, etc Table 2 has 3 fields: Account ID, Employee ID, Commission Date Both tables have the same Account ID and Employee ID information. What I want to do is I want to pull...
  3. E

    Vlookup equivalent in Access?

    Hi all, I am currently working on an Access project. I have 2 tables: Table 1 has 10 fields: Account ID, Employee ID, etc Table 2 has 3 fields: Account ID, Employee ID, Commission Date Both tables have the same Account ID and Employee ID information. What I want to do is I want to pull...
Top Bottom