LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 173
Default Append key fields for import to ACCESS

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


 
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
Missing fields when I import from Access to Excel... AAOO (Sean) New Users to Excel 2 November 4th 06 10:38 PM
Fields in recordset from Access with value Null (empty fields) Mats Nilsson Excel Programming 2 September 20th 06 05:51 PM
Help: Import text transpose append to new worksheet javamom Excel Programming 4 April 20th 06 03:29 AM
I can import Access Tables. But, I can't import Access queries nickg420[_8_] Excel Programming 0 August 5th 04 07:46 PM
use vba in excel to append data in access sakijung[_2_] Excel Programming 0 April 7th 04 07:16 AM


All times are GMT +1. The time now is 07:04 AM.

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

About Us

"It's about Microsoft Excel"