Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Append to excel workbook
- Thread starter scottian
- Start date
Why not pulling the info from within Excel instead of pushing when in Access ?
Anyway the short answer is Yes:
take a look at OLE Automation and the CopyFromRecordset method of the Excel.Range object
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
Anyway the short answer is Yes:
take a look at OLE Automation and the CopyFromRecordset method of the Excel.Range object
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
- Thread starter
- #3
The problem i have is that the workbook is shared, and sometimes im locked out because another user is updating it, Id like to use access to try to append the data, if the workbook is locked, to keep trying until the data has been appended. so pulling from the workbook would defeat my purpose.
"My God! It's full of stars...
"My God! It's full of stars...
- Status
Similar threads
- Question
- Locked
- Question
