asked on Using power query in excel to combine 3 excel spreadsheets into one error field content of the record was not found???
I am using power query editor to import 3 excel workbooks into one workbook. I took these steps 1. Create new workbook 2. under – data – new query - from file – from folder (Path containing the 3 files) then transform then add column. 3. I created my new column name then added the formula Excel.Workbook([content]).
I get the following error message and it will not merge the files. Expression.Error: The field 'content' of the record wasn't found.
Details:
Content=[Binary]
Name=Address_MySql.xlsx
I get the same for each of the files I want to merge??? Not sure how to resolve
I get the following error message and it will not merge the files. Expression.Error: The field 'content' of the record wasn't found.
Details:
Content=[Binary]
Name=Address_MySql.xlsx
I get the same for each of the files I want to merge??? Not sure how to resolve
Microsoft ExcelMicrosoft Office
Last Comment
Tom Farrar
What version of Excel are you using?
ASKER
If am not sure what to do once I am in the combine load menu. I get
combine files
select object to be extracted
sample file: first file and a drop down with the spreadsheets --- Do I choose something here I can only choose one sheet at a time. Do I have to choose each sheet seperatly to load them into one master blank spreadsheet that I want to create??? Not sure the steps to take in this menu to load all my sheets into one master excel sheet... Perhaps there is a better path??? Thanks
I am using microsoft office professional 2016
combine files
select object to be extracted
sample file: first file and a drop down with the spreadsheets --- Do I choose something here I can only choose one sheet at a time. Do I have to choose each sheet seperatly to load them into one master blank spreadsheet that I want to create??? Not sure the steps to take in this menu to load all my sheets into one master excel sheet... Perhaps there is a better path??? Thanks
I am using microsoft office professional 2016
ASKER
When I go into account from the file menu and about excel I get a pop up the states about microsoft excel 2016 - so I think 2016 is the version. Hope that is right.
Do me a favor. Save the three files as .csv files and not .xlsx. Then go to import from folder. Click the down arrows above content.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I tried the above process. When I run the combine and load only one table from the worksheets gets loaded onto my new spreadsheet. The excel files are small as I condensed them for testing. In my workbook query (power query) I have a message that states loading data and it will keep running with no results. The other worksheets will not load. I will try the csv approach but I wanted to keep the formatting on the spreadsheets.
Patricia
When you follow the steps outlined in that link does everything described happen?
For example, do you see a list of files once you've browsed and selected the relevant folder?
ASKER
Yes I do see a list of files. When saving the excel sheets as csv which fomat should I use ot sure what utf-8 csv is or should i use just csv? Thanks again. If helpful I can send an attachment
I believe .csv works fine..
ASKER
thanks why would someone use utf-8 anyway
From the web..
UTF-8 can represent any character in the Unicode standard and it is also backward compatible with ASCII as well. It is the most preferred encoding for e-mail and web pages. It is the dominant character encoding for the world wide web.Aug 10, 2016
I have not had a use for this, so I am no expert here.
UTF-8 can represent any character in the Unicode standard and it is also backward compatible with ASCII as well. It is the most preferred encoding for e-mail and web pages. It is the dominant character encoding for the world wide web.Aug 10, 2016
I have not had a use for this, so I am no expert here.
ASKER
I have attached my steps. I do this before my combine and load
importing_combining_excel_sheets_ex.docx
importing_combining_excel_sheets_ex.docx
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See if this walks you through the process with Excel Files.
https://www.google.com/search?q=import+excel+files+from+folder+power+query&rlz=1C1AWFC_enUS757US757&oq=importing+excel+files+from+folder+p&aqs=chrome.1.69i57j0l3.21333j1j8&sourceid=chrome&ie=UTF-8#kpvalbx=_55o4Xvm6GIG4sgWTg7ywBQ26
https://www.google.com/search?q=import+excel+files+from+folder+power+query&rlz=1C1AWFC_enUS757US757&oq=importing+excel+files+from+folder+p&aqs=chrome.1.69i57j0l3.21333j1j8&sourceid=chrome&ie=UTF-8#kpvalbx=_55o4Xvm6GIG4sgWTg7ywBQ26
ASKER
Thanks got it finally
Glad we finally got there..
Patricia
Did you select Combine & Load after you'd selected the folder and the files were listed?