Append key fields to range for ACCESS import.

M

MikeF

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append key fields to range for ACCESS import 0
Append key fields to range for ACCESS import 0
Append key fields to range for ACCESS import. 0
Append key fields to range for Acess import 0
Append key fields for import to ACCESS 0
Append key fields to range for ACCESS import. 0
One-cell range as key field to ACCESS import 0
Add/imply fields when importing range into ACCESS 6

Top