Importing from Training Partner - Blank Columns

  • Thread starter Thread starter CarolH
  • Start date Start date
C

CarolH

When I import a report from Training Partner into .xls it brings a blank
column between every column with data. Is there a way to remove this blank
column before it exports the file (I can certainly delete the blank columns
once it has arrived in .xls). Thank you for your advice.
 
When I import a report from Training Partner into .xls it brings a blank
column between every column with data.  Is there a way to remove this blank
column before it exports the file (I can certainly delete the blank columns
once it has arrived in .xls).  Thank you for your advice.  

If it's coming from a report, then I don't think so. You could write
a macro in Excel to do it, though... you could even just record it and
then call it from Access if you wanted.
 
Back
Top