Search results

  1. E

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

    Hi, Can anyone help me on this? Thanks
  2. 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...
  3. E

    Vlookup equivalent in Access????

    how do you join tables in a query? and do i need to join the matching fields using the "join category" feature?
  4. 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...
  5. 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...
  6. E

    Equivalent of vlookup in access?

    Hi, I have a follow up question on this one. How do you create a query combining the two tables? How do you change it to an update query?? Thanks
Back
Top Bottom