View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MikeF[_2_] MikeF[_2_] is offline
external usenet poster
 
Posts: 173
Default Append key fields to range for Acess 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 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