merge cells for excel, through access

[reta]

Hi i am importing an excel file into access, but i need to merge the first two cells in the excel file before the file is imported, as the headings are broken up in to two cells.
I know how to merge cells in excel, but i need to know how to merge cells in the excel file through access, is that possible.
Reta

 

[PHV]

Play with OLE Automation instantiating an Excel.Application object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[reta]

ive tried range("A2:A3").Select but it cannot recognise the select....

 

[PHV]

As your VBA is not hosted by Excel you have to full qualify all the Excel's object:
myXLobj.range("A2:A3").Select

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[reta]

FieldNames = wsobj.Range("A2:A3").Select
the error that i am getting is
"Unbale to get the select property of range class"

 

[PHV]

Can you please post the code you have so far and what you want to do ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244