Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add/imply fields when importing range into ACCESS
When importing a named range from Excel into Access...
- columns C thru J, rows starting at 6 but ending differently all the time - ... am looking to add 2 named 1-cell ranges from Excel - that are *not* included in the orignal named range - to the import, ie CityID and EventID --- to their corresponding fields in Access. - Excel range to import: MyExcelRange This range begins in column C in Excel. *** Does *not* contain the following in Excel, both of which need to be imported to Access, as many rows as required: - Excel 1-cell range to add/imply upon import to Access - in the 1st field to the left in Access [column B *IF* it were in Excel] : EventID - Excel 1-cell range to add/imply upon import to Access - in the 2nd field to the left in Access [column A *IF* it were in Excel] : CityID Of course, this could be physically re-constructed on another tab in Excel, but ... a) This schema is required for multiple tabs. b) It would be redundantly using large groups of data. b) The workbook size would start to become prohibitive. Any assistance would be greatly appreciated. And please let me know if this needs clarification. Regards, - Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Access DB into Excel changes my calculated fields in Exc | Excel Worksheet Functions | |||
Append key fields to range for ACCESS import | Excel Programming | |||
Append key fields to range for ACCESS import | Excel Programming | |||
Append key fields to range for ACCESS import | Excel Programming | |||
Importing data from Access into Excel: prob w/ cutting off fields | Excel Worksheet Functions |