Linked Table - Excel - Blank Column A (1 Viewer)

[razorking]

Have you asked the vendor WHY? Maybe he can instruct his people in the proper construction of the spreadsheet if the difference is caused by carelessness.

I have not but will give it a try.

 

[pdanes]

How about making your source query dynamic? Something like {aircode):

Select Iif(Col(1)="", Col(2),Col(1)) As ColA, Iif(Col(1)="",Col(3),Col(2)) As ColB, Iif(Col(1)="",Col(4),Col(3)) As ColC, etc.

This would allow you to use the stuff starting from column 1 if column 1 contains data, or start with column 2 if column1 is empty.