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!
Access to Excel
- Thread starter ggswtexas
- Start date
So what kind of problems. Using DoCmd.TransferSpreadsheet is a relatively easy command. You must make sure the SpreadsheetType is supported by your version of Excel.
DoCmd.TransferSpreadsheet TransferType:=acExport, _ SpreadsheetType:=acSpreadsheetTypeExcel9, _
TableName:=mstrQuery, _
Filename:=strWriteFileSpec
Steve King Growth follows a healthy professional curiosity
DoCmd.TransferSpreadsheet TransferType:=acExport, _ SpreadsheetType:=acSpreadsheetTypeExcel9, _
TableName:=mstrQuery, _
Filename:=strWriteFileSpec
Steve King Growth follows a healthy professional curiosity
- Thread starter
- #3
I when I try to use any type of Docmd command it says that there was problems with the OLE and the data could not be transfered. Also, when I try to register the OLE references in VB it tells me that there is an error in linking to the .dll file. I have tried to reload access and that did not work. What could be causing this problem with the OLE?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
