Exporting only columns with data

  • Thread starter Thread starter Maracay
  • Start date Start date
M

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
 
Thanks

Chris O'C via AccessMonster.com said:
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
 
Back
Top