Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
One-cell range as key field to ACCESS import
Would like to "imply" two one-cell ranges by appending them to an existing
range, meant for import into Access. Existing range: MyAccessRange, columns A thru J, rows changing all the time, but for now say 10-100. Data exists only in columns C thru J. The one-cell ranges 1id and 2id are necessary as Access key fields: - 1id needs to be "implied" into column A, as many rows as required. - 2id needs to be "implied" into column B, as many rows as required. I could physically construct another tab for this, but ... a) This schema is required for multible 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import into Access from Excel, passing a variable for the field... | Excel Worksheet Functions | |||
import excel to Access has a problem with text field | Excel Worksheet Functions | |||
Field , Date range and Sum from worksheet import | New Users to Excel | |||
import date field from access into excel | Excel Programming | |||
import date field from access into excel | Excel Programming |