Trying to upload the Excel file .XLS format with 10 sheets of 150MB, but Alteryx could not read the sheets and received the error message "Timed out in DataWrap2_InboundNamedPipe::ReadFile: after 30000 milliseconds"
@troy_mech a way around this, is to save the XLS to XLSX (Excel > File > Convert)
If you want to just read the data in, you can save it as a CSV file in Excel.
Thank you for your solution, it works perfectly.
I'm having a similar issue when I try to connect and Access database and run an SQL query. I followed the advice here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Troubleshooting-Microsoft-Access-read-write-issues/ta-p/19187
and downloaded AccessDatabaseEngine_X64.exe to connect the Access database to Alteryx. Seems to be installed correctly but the SQL query wont run.
Hi
I am facing the same issue while loading into .mdb (Microsoft Access 2000-2003) .In that case what we do to resolve this issue ?
Alteryx version ; 2021.3.2.54175
