Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import from Acess problems with SQL language toby131 Excel Discussion (Misc queries) 1 November 14th 09 01:38 AM
Append key fields to range for ACCESS import. MikeF[_2_] Excel Programming 0 February 10th 09 11:29 PM
Append key fields to range for ACCESS import. MikeF[_2_] Excel Programming 0 February 10th 09 06:21 PM
Append key fields to range for ACCESS import MikeF[_2_] Excel Programming 0 February 10th 09 04:27 PM
Append key fields for import to ACCESS MikeF[_2_] Excel Programming 0 February 10th 09 04:20 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"