Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() The sheet names in excel when you use the ADO method (or any SQL) requires you to add a dollar sign at the end of the sheet name So acImport becomes acImport$ -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=177803 Microsoft Office Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TransferSpreadsheet to colored fields | Excel Worksheet Functions | |||
Access 2003: transferspreadsheet writes over existing spreadsheet | Excel Discussion (Misc queries) | |||
Delete Worksheets Prior To Access DoCmd.TransferSpreadsheet | Excel Programming | |||
Export to Range from Access with TransferSpreadsheet | Excel Programming | |||
how to rename sht after TransferSpreadsheet method? | Excel Programming |