Exporting only columns with data

[Maracay]

Hi Gurus,

I have a table that I want to export, this table have lots of empty columns,
there is a way to export to excel only the columns with data?

Thanks

 

[Chris O'C via AccessMonster.com]

Write a query with only the columns you need and export the query.

Just fyi, a table with lots of empty columns is often a sign of an
unnormalized table.

Chris

 

[Maracay]

Thanks

Write a query with only the columns you need and export the query.

Just fyi, a table with lots of empty columns is often a sign of an
unnormalized table.

Chris