Importing from Training Partner - Blank Columns

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.
 
P

pietlinden

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

How to save/repeat an import from Excel 1
Type Conversion Failure importing number as text 1
Access crashes when I try to import an excel file 7
Import Blank fields from Excel 1
Importing fields from separate excel sheets to fill in info in dba 3
Macro: finding a cell on one worksheet and copying to another worksheet 0
Export to Pocket Excel 1
import excel data - scientific notation 1

Top