Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tunna991
  • Content: Threads
  • Order by date
  1. tunna991

    Import multiple excel Worksheet / workbook to a single table in Access 2010

    This is a situation I recently encountered. My department has over 500 excel files with multiple tabs. We want to import the data from specific tabs into one excel database. These tabs will contain the same columns. I am not good with VBA and could not find a solution after much googling. Also...
  2. tunna991

    Import multiple excel Worksheet / workbook to a single table in Access 2010

    This is a situation I recently encountered. My department has over 500 excel files with multiple tabs. We want to import the data from specific tabs into one excel database. These tabs will contain the same columns. I am not good with VBA and could not find a solution after much googling...
  3. tunna991

    Excel formula to check a range for blanks and another cell for a value

    I am stuck with a formula. Basically I want to check if a range of cells is blank, and then another cell which has the word "Yes" in it. If all that is true then condition should be a true or false if not. Here is a breakdown of the tables: The formula I am using is as follows...
  4. tunna991

    Inserting into Temp tables and Union Queries

    Hi there, I have a few queries that I need to join because they have the same structure. As well I have three temp table in my query that I want to use across the different queries. I tried the 'insert into' commend in the temp tables but that did not work. I think it would not be effective...

Part and Inventory Search

Back
Top