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.  
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Importing 33 fields into a 58 field table (and changing data order 3
How to save/repeat an import from Excel 1
XLS Spreadsheet Import to Access 2007 being rearranged 5
Type Conversion Failure importing number as text 1
Importing fields from separate excel sheets to fill in info in dba 3
Access-Excel Import Wizard problem 1
import excel data - scientific notation 1

Back
Top