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!

  • 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: *

  1. tunna991

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

    Thank you that really helped. I was able to make it work. Basically I was placing the names of the three columns in the wrong place. One more thing before I can close this thing off, is that is there a way to have another column with the Tab name the record is being pulled from? For example...
  2. tunna991

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

    Thanks for your help thus far. I would appreciate seeing the workbook you are using.
  3. tunna991

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

    Is there any way you can help me to modify the code I posted initally. I know it doesnt have the delete blanks function, I can figure that part out later.
  4. tunna991

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

    Your code is almost getting me there. The thing that is not working are the three extra columns I need to capture from the information tab. Also it crashes when the folder has multiple files.
  5. tunna991

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

    Actually it stops at this line... Set wsOUT = Worksheets("Master")
  6. tunna991

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

    Hi Skip. ' It says subsscript out of range when it comes to the following line. Set oFSO = CreateObject("Scripting.FileSystemObject")
  7. tunna991

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

    OK so the below code pasted should look better for the eyes Now regarding the earlier point I am including an attachment to make things more clear. Just for privacy reason I have changed the labels and data drastically :) The file is at...
  8. tunna991

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

    Very sorry for the confusion. How exactly do I use the TGML tags? I clicked the TGML checkbox and it seems to be making no differece.
  9. tunna991

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

    Thanks for the code Skip. I will try this when I get to work. How would I add in another row and populate it with a value from a sheet from the file I am merging from?
  10. tunna991

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

    Great. How about the information tab name? Basically the users download this report from a larger reporting system. The information tab contains information like date of report and the name of the location. Basically for each excel file I import into access, I would like to capture the...
  11. tunna991

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

    There are 5 tabs out of the 9 I need in from there. Yes they all have headings that start in A1. Yes and all 500 files will be in one folder. Thank you kindly for your help.
  12. 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...
  13. 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...
  14. 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...
  15. tunna991

    Inserting into Temp tables and Union Queries

    Thanks for your pointers. I think I am closer to figuring this out. Now in the Identity SQL statement which will create an incrementing record number, I have tried the insert into statement like this SELECT IDENTITY(int, 1,1) AS 'RN', #temp.[Participant ID||] AS 'tp' Insert INTO #temp_2...
  16. tunna991

    Inserting into Temp tables and Union Queries

    First of all, thanks for all the help so far. Basically this query is not optimized or the best way to perform my task. This was done by a person who was here before me. I have tried to build on it but have been away from SQL for a while now. What I am trying to do is get data for an alternative...
  17. 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