dstone8484
New Member
- Joined
- Jun 20, 2012
- Messages
- 1
I have about 6 external access queries linked on 1 excel sheet. For the external properties I have chosen Insert cells for new data, delete unused cells, dont adjust column widths, and keep cell formating.
Adding and losing rows ussallys works OK except when there is no data in one of the queries. When there is no data, 1 record stays and replaces the header row. (Even though the queries does not come back with any results). The header row is the one being deleted instead of the record row
Can anyone help with this
Adding and losing rows ussallys works OK except when there is no data in one of the queries. When there is no data, 1 record stays and replaces the header row. (Even though the queries does not come back with any results). The header row is the one being deleted instead of the record row
Can anyone help with this