Importing workbooks from a folder

[howard]

I have tried to import a file from a folder, but get data format error

I selected Data > New Query > From File > from Folder. I then browsed to the folder and clicked Ok

I then clicked on the Binary expansion button and get a data format error

Attached please find sample files

https://www.dropbox.com/s/rsibfiax0ml4ec5/BR1 Sales Report Dec 2017.xlsm?dl=0
https://www.dropbox.com/s/83n5oqi4hi8bziz/BR1 Sales Report Jan 2018.xlsm?dl=0
https://www.dropbox.com/s/urg12xhmdrebkto/Data Format Error.PNG?dl=0

I have also posted on link below

https://www.excelforum.com/excel-fo...error-when-importing-files-from-a-folder.html


It would be appreciated if someone could assist me on how to resolve this

 

[sandy666]

Re: Importing workbooks from a folfer

did you try Combine and Edit?

 

[howard]

Re: Importing workbooks from a folfer

hi Sandy

don't I first need create new query from Folder before combining ? If not please advise of steps to follow to do this

 

[sandy666]

Re: Importing workbooks from a folfer

I mean:

nb. I have no error using Expand on Binary column after Edit only

 

[howard]

Re: Importing workbooks from a folfer

Hi Sandy


I am using Office 2016 and the combine facility is not available on this version


see screen print on drop box link below



https://www.dropbox.com/s/sksmjzt98cxrndf/Screen Print from Folder.PNG?dl=0

 

[sandy666]

Re: Importing workbooks from a folfer

afaik this option exist for 2010/2013 PQ add-in also
it was done with 2016 as well

maybe update your Office...

 

[howard]

Re: Importing workbooks from a folfer

Hi Sandy

Thanks for the help

I ran the Office update and the functionality to combine is now available


I can now import the data from the folder without any errors

 

[sandy666]

Re: Importing workbooks from a folfer

I am glad it works for you

Have a nice day