 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / July 2005linking an excel file
Hi all I want to import an excel file with transferspreadsheet Is there a way to specify a range like from the 6th row to the bottom (may vary from one import to an other) I was looking for something like sheet1!a6: Someone know the correct syntax? is it possible? what is the simplest way to do so pierre docmd.TransferSpreadsheet acLink,acSpreadsheetTypeExcel9,"_xlact","E:\VOUGHT 2005\2005 Actuals\IT Services\Vought IT Services June 2005.xls",true,"actual_res_export!D6:AN" Notice in the range argument, there is not row number after column AN. This will make the table start at row 6 and include rows D through AN from row 6 to the bottom of the spreadsheet. Empty rows will not be imported. > Hi all > [quoted text clipped - 12 lines] > > pierre |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.