Use the power of query merge multiple files within a folder to a summary tables, queries can query, but to shut down and upload this step, the worksheet display failure, can only display a few lines before why? Tried many times can't again, just began to suspect that is because the data set the effectiveness, cancel the validity or not, and a table there is a null columns is suspected, the not null columns to delete, hidden this field show false, is this why? But also don't understand why is false, hiddenhidden tried many times, great god give directions, thank you!

CodePudding user response:

Tip is loaded into the worksheet failure: initialization data failed, please check the database server or contact your database administrator, confirm the effective external database, and then retry the operation, if there is still a this information, please create a new data source to connect to the database,