B bugsy Registered User. Local time Yesterday, 17:51 Joined Oct 1, 2007 Messages 99 May 2, 2008 #1 i usually use TransferSpreadsheet does anyone know where i put the tab, if excel has several tabs ? Code: DoCmd.TransferSpreadsheet acImport, , "TableInAccess", pathFromExcel, vbYes
i usually use TransferSpreadsheet does anyone know where i put the tab, if excel has several tabs ? Code: DoCmd.TransferSpreadsheet acImport, , "TableInAccess", pathFromExcel, vbYes
Z Ziggy1 Registered User. Local time Today, 01:51 Joined Feb 6, 2002 Messages 462 May 2, 2008 #2 DoCmd.TransferSpreadsheet acImport, , "TableInAccess", pathFromExcel, vbYes,"Sheet1!A1:E20" you'd have to play around with it, I haven't tried it, but it is the Range you have to work with...the sheet name alone may work also?
DoCmd.TransferSpreadsheet acImport, , "TableInAccess", pathFromExcel, vbYes,"Sheet1!A1:E20" you'd have to play around with it, I haven't tried it, but it is the Range you have to work with...the sheet name alone may work also?
