Using a query to detect blank columns

Richhol65

Registered User.
Local time
Today, 07:53
Joined
Aug 24, 2013
Messages
43
Hi

I am importing a spreadsheet on a daily basis that has the same columns in every time but depending on the company I am importing it for different columns will be blank and not needed each time.

What is the best way of detecting and removing blank columns

Thanks

Rich
 
Richhol, In the properties of the table you are importing to change the Validation rule "Allow Zero Length" to NO. This should then not import blank columns.
 
Or in the query criteria put ....Is not null
 
Hi Hights

the problem is that it can be different columns every time so say the first time I import it could be column G, Column AA, Column BC that are blank and the next time it could be 12 totally different columns

Cheers

Rich
 

Users who are viewing this thread

Back
Top Bottom