Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2007
    United States
    Thanked 0 Times in 0 Posts

    Stop Exporting Blank Values into Excel (Access 2003)

    I am trying to export tables and queries from an Access database into Excel so that I can use the Excel features. However, when the table or query table is exported, blank cells that are part of the table seem to be registering as a valued cell. That is, if I use a COUNTA function on one of the columns of the table in Excel it counts all of the records and not just the records that have actual values in the cells. If I go to the "blank" cells and press DELETE, the COUNTA function doesn't count that cell like it is supposed to.

    How can I get a "cleaner" export into Excel.

    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Stop Exporting Blank Values into Excel (Access 2003)

    This happens frequently when exporting from databases to Excel (not just from Access). I don't think there is anything you can do on the Access side. You can run a macro in Excel to clear such cells - see <post#=136,921>post 136,921</post#> by Legare Coleman.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts