For each field in your QueryDef , set the field's .Properties("ColumnOrder").Value = 0. Here is an example in the Immediate window.
Using the query builder in the form and sorting the field through the query may work.
This resets the order of the columns to match the order of the questions
If the query is saved before any datasheet layout changes,
to register. If you forgot your password, you can reset your password.
The External Data window appears automatically after you have successfully linked shapes in your Visio drawing to an external data source such as Excel ...
Hi, I am new to Power BI, but I can not understand why the order of columns which was in Edit Query phase(no reordering was applied to ...
Support for Office 2010 ended on October 13, 2020. Upgrade to Microsoft 365 to work anywhere from any device and continue to receive support. Upgrade now.
In case it's relevant, my data source is an Excel spreadsheet.
I have a database with many queries and macros. Our procedure to run this database is to copy data from an Excel spreadsheet and paste it into ...