ExcelToAccessMultiSheetsStyle2 |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 28 Nov 2011 at 11:12am |
ExcelToAccessMultiSheetsStyle2 This sample db demonstrates import of data from excel, spread over multiple sheets. Two styles are covered:
(a) Excel workbook with pre-defined range names. Sample excel files (WithRangeNames.xls and WithoutRangeNames.xls) are located in the home folder that contains this sample db. First row of each data block carries field names. In style (b) similar information is displayed, based upon programmatic detection of data blocks in excel workbook, matching the first field name provided by the user. For greater precision, if desired, the user can also optionally enter column count and name of last field. Amongst data blocks displayed in the subform, those required to be imported can be identified by clicking check boxes in column headed "Include". For items selected in this manner, the text box at right gets populated with a comma separated list of data blocks earmarked for import. Based upon user choice in the option group, this list is made up either of range names (applicable to style (a) only), or cell addresses or column addresses. The list is editable, allowing the user to carry out any modification if desired. An option group provides a choice for the mode to be adopted for import action (i.e. whether as per pre-defined ranges or as per user specified cell or column addresses). On clicking the appropriate command button, data blocks covered by above list get imported into access. For added convenience, command buttons have been provided for viewing the Imported data as well as the excel file - if desired. Supplementary Notes: 2 - User defined address string using comma as separator between adjacent blocks (no spaces) serves as one of the arguments for import subroutine. Either of the three sample styles given below can be used (Orders_01 is the name of worksheet): Note: 3 - Important: Download File >>: uploads/37/ExcelToAccessMultiSheetsStyle2.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |