# Error EXCEL QUERY component after DATA TRANSFER component (Sharepoint \> S3) **URL:** \ **Category:** Matillion ETL\ **Created:** [April 22, 2022, 3:44pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732 "2022-04-22T15:44:17Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![aurelie.gabarre](https://avatars.discourse-cdn.com/v4/letter/a/aca169/32.png) [@aurelie.gabarre](https://matillioncommunity.discourse.group/u/aurelie.gabarre)\ **Post date:** [April 22, 2022, 3:44pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/1 "2022-04-22T15:44:17Z")
I saved en excel file in a sharepoint (39ko). After that, with DATA TRANSFER component, I upload the excel file from my sharepoint to my S3 bucket. The component runs without error and I see the file in my S3 bucket (but more bigger than at the beginning : 183ko).   Then I try to do an EXCEL QUERY to load my S3 bucket file excel into a table. But, I get an error "Error loading file: Te central directory was nos found." . It doesn't recognize my file as an excel file.   Is there a particular parameter in my data transfer component to make it understand that it is an excel file? Any other solution? ---
**Author:** ![luis.arteaga](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@luis.arteaga](https://matillioncommunity.discourse.group/u/luis.arteaga)\ **Post date:** [April 22, 2022, 4:33pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/2 "2022-04-22T16:33:02Z")
Try to upload the excel file directly into s3 for testing purposes and use the Excel Query again. Same error message? If not I would recommend to check your settings for the Data Transfer component. ---
**Author:** ![luis.arteaga](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@luis.arteaga](https://matillioncommunity.discourse.group/u/luis.arteaga)\ **Post date:** [April 22, 2022, 4:37pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/3 "2022-04-22T16:37:47Z")
And no you don't need to specify the data type in the data transfer component. ---
**Author:** ![aurelie.gabarre](https://avatars.discourse-cdn.com/v4/letter/a/aca169/32.png) [@aurelie.gabarre](https://matillioncommunity.discourse.group/u/aurelie.gabarre)\ **Post date:** [April 22, 2022, 5:36pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/4 "2022-04-22T17:36:34Z")
 I tried to load the excel file into the S3 bucket myself, the excel query component works fine that way. But, what I need is to be able to load documents in S3 without having to do the manual manipulation (automation). ---
**Author:** ![luis.arteaga](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@luis.arteaga](https://matillioncommunity.discourse.group/u/luis.arteaga)\ **Post date:** [April 22, 2022, 6:04pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/5 "2022-04-22T18:04:36Z")
Hi Aurelie,   yes, I think I understand your problem. I just wanted to narrow down the problem. So it has definitely to do with the data transfer component.   Does the excel file copied via the Data Transfer component have the same file size like the original file? Maybe you just created a file with the same name but didn't copy anything at all.   I had the same problem. My mistake was that I didn't specify the source path of the file correctly. Unfortunately in this case the data transfer component wouldn't detect any error, instead it would just create an empty file with the defined target file name.   I would check your path to the source file again. ---
**Author:** ![luis.arteaga](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@luis.arteaga](https://matillioncommunity.discourse.group/u/luis.arteaga)\ **Post date:** [April 22, 2022, 6:06pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/6 "2022-04-22T18:06:22Z")
e.g. folder/subfolder/filename.xslx ---
**Author:** ![aurelie.gabarre](https://avatars.discourse-cdn.com/v4/letter/a/aca169/32.png) [@aurelie.gabarre](https://matillioncommunity.discourse.group/u/aurelie.gabarre)\ **Post date:** [April 22, 2022, 6:15pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/7 "2022-04-22T18:15:05Z")
I saved en excel file in a sharepoint (39ko). After that, with DATA TRANSFER component, I upload the excel file from my sharepoint to my S3 bucket. The component runs without error and I see the file in my S3 bucket (but more bigger than at the beginning : 183ko).So, not the same size at all, and the path is the good one.   When I try to save this new file fom S3, it's not an excel, just something like xml. that's why, I think the data trasnfer component had a problem, but i don't know where...     ---
**Author:** ![luis.arteaga](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@luis.arteaga](https://matillioncommunity.discourse.group/u/luis.arteaga)\ **Post date:** [April 23, 2022, 10:07am UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/8 "2022-04-23T10:07:20Z")
I see. Weird. You could write to support@matillion.com or wait for more comments. Could you post your Data Transfer settings (maybe anonymize sensitive information)? This might help others and me to support you more efficiently. ---
**Author:** ![Michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@Michael](https://matillioncommunity.discourse.group/u/Michael)\ **Post date:** [April 29, 2022, 1:40pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/9 "2022-04-29T13:40:27Z")
Do you have the "Unpack File" option activated? IIRC the modern Excel formats are just zipped XMLs. Maybe the component misinterprets the file and tries to extract your Excel file?! If that's not the case, I think contacting support would indeed help best. ---
**Author:** ![aurelie.gabarre](https://avatars.discourse-cdn.com/v4/letter/a/aca169/32.png) [@aurelie.gabarre](https://matillioncommunity.discourse.group/u/aurelie.gabarre)\ **Post date:** [April 29, 2022, 2:52pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/10 "2022-04-29T14:52:03Z")
Hello Michael, When I activate the "Unpack File" option, I can't run my component. I got an error : "Error unpacking Zip file. Zip file is empty or corrupted."   I already contacted support, I'm waiting for a solution... ---
**Author:** ![m.keysight](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@m.keysight](https://matillioncommunity.discourse.group/u/m.keysight)\ **Post date:** [December 16, 2022, 5:19pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/11 "2022-12-16T17:19:52Z")
Hi Aurelie, did support ever get back to you regarding this? Running into the same problem ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [January 18, 2023, 4:37pm UTC](https://matillioncommunity.discourse.group/t/error-excel-query-component-after-data-transfer-component-sharepoint-s3/1732/12 "2023-01-18T16:37:14Z")
Hey [@m.keysight](https://matillioncommunity.discourse.group/u/m.keysight)​ I am really sorry to learn you have a similar issue, I would recommend also reaching out to our support them at support@matillion.com and they take a look at this for you and resolve the issues you are having. Kind regards, Joe