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!
Search results for query: *
- Users: AlanTylman
- Content: Threads
- Order by date
-
TransferSpreadsheet is creating 3 sheets
Hi I am trying to export a query from Access 2003 to Excel 2003 that has over 17000 lines and I am trying to use the TransferSpreadsheet command as below. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "{query name}", "{file path}" The spreadsheet is created but has 3 sheets...- AlanTylman
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
