I have a table in an Excel file which has a connection to an Access Query. When I first create the table in Excel, the data comes in with exactly the same order as how I set up the Access query. When I change something in the Access query, for example if I change the name of a field but don't change the data that comes in, in Access that column stays in the same place. But, in Excel, when I refresh the table, that column now comes at the end. I need the columns to be in a certain order and I put them in the correct order in Access but they're not coming in the same order in Excel. And, I need to be able to change the fields in Access from time to time without having to do a ton of work to get the columns back in the correct order in Excel.
Any ideas? Thanks!