Import/link excel spreadsheet with merged cells?

  • Thread starter Thread starter stripedfrog
  • Start date Start date
S

stripedfrog

I have an excel spreadsheet that I have to manipulate whenever I get it from
corporate. That being said, there's no chance of getting them to send the
spreadsheet in a manageable form. LOL

I would like to link the form to Access so that I won't have to go through
this every month but can't due to merged cells. Is there anyway to link or
even import selected cells from a spreadsheet?


Background of what I'm trying to accomplish:

The report I receive has all information including obsolete data that has to
be "weeded out" every month in order to see the real picture. So even when I
import into Access I need to find a way to distinguish the current from the
obsolete.

ANY HELP WOULD BE APPRECIATED. =oD
 
You can do this; however, it is not an easy task. Hopefully, you are good
with VBA. You will have to learn how to create an Excel Application object
in Access and manipulate it cell by cell.
 
You can't link or import data that's in or among merged cells.

If the data you need is in a contiguous rectangular range of cells (none
of them merged), you can use the TransferSpreadsheet macro or VBA method
to import or link it even if there are merged cells elsewhere on the
sheet.

To do this you can either use Excel's Insert|Name|Define feature to name
the range, and then use the name as the Range argument of
TransferSpreadsheet; or else give TransferSpreadsheet a range like this:
"Sheet1$A5:G50".

If there are any merged cells in the data area, delete the rows (or
columns) involved, or else unmerge the cells and sort out their
contents.
 
Back
Top