R
Rach
Hi everyone,
Really need some help? I have attached an OLE object embedded (Excel) to a
form and I need a separate form to import the information contained within
it. I have succeeded in importing the information from an external source
e.g. C: using code
DoCmd.TransferSpreadsheet acImport, , _
"Report", "C:\Source Files\Outstations\Outstations Log Test Data.xls", ,
"A2
300"
I have tried to attempt the same using importing the spreedsheet within
Access from the other form but it is not successfull. Anyone have any clues?
Really need some help? I have attached an OLE object embedded (Excel) to a
form and I need a separate form to import the information contained within
it. I have succeeded in importing the information from an external source
e.g. C: using code
DoCmd.TransferSpreadsheet acImport, , _
"Report", "C:\Source Files\Outstations\Outstations Log Test Data.xls", ,
"A2
300"I have tried to attempt the same using importing the spreedsheet within
Access from the other form but it is not successfull. Anyone have any clues?