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...
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.
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.
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...
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?
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...
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.
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.