frankee_gee
Board Regular
- Joined
- Mar 3, 2008
- Messages
- 144
- Office Version
- 365
- 2016
- Platform
- Windows
Please help,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a spreadsheet with 5400 records/rows. This will be imported into an Access 2007 DB. This DB has multiple tables including lookup tables. <o></o>
<o></o>
In Excel the contents of column "D" titled UnitID, must be converted to numbers, which will very from 1 thru 96 depending on the content.<o></o>
<o></o>
All 96 lookup values are in a second sheet in this excel book. <o></o>
<o></o>
Say in sheet "Tag_Log" cell D6 = Boiler<o></o>
<o></o>
In sheet "Units" B29 = Boiler and A29 = 28<o></o>
<o></o>
Want "Tag_Log" cell D6 = 28<o></o>
<o></o>
How can this be accomplished?<o></o>
<o> </o>
<o> </o>
Want the Current UnitID column in Sheet: “Tag_Log” (Data).<o></o>
<o> </o>
To be replaced by UnitID column in Sheet: “Units”(Lookup Table).<o></o>
<o> </o>
Must match UnitID column in sheet: Tag_Log to UnitNo in sheet: “Units”. Then take the number in column A UnitID in that same row and replace the contents of UnitID in sheet: Tag_Log.<o></o>
How can this be done?
Thanks for your help.
Frank.
<o></o>
I have a spreadsheet with 5400 records/rows. This will be imported into an Access 2007 DB. This DB has multiple tables including lookup tables. <o></o>
<o></o>
In Excel the contents of column "D" titled UnitID, must be converted to numbers, which will very from 1 thru 96 depending on the content.<o></o>
<o></o>
All 96 lookup values are in a second sheet in this excel book. <o></o>
<o></o>
Say in sheet "Tag_Log" cell D6 = Boiler<o></o>
<o></o>
In sheet "Units" B29 = Boiler and A29 = 28<o></o>
<o></o>
Want "Tag_Log" cell D6 = 28<o></o>
<o></o>
How can this be accomplished?<o></o>
<o> </o>
<o> </o>
Want the Current UnitID column in Sheet: “Tag_Log” (Data).<o></o>
<o> </o>
To be replaced by UnitID column in Sheet: “Units”(Lookup Table).<o></o>
<o> </o>
Must match UnitID column in sheet: Tag_Log to UnitNo in sheet: “Units”. Then take the number in column A UnitID in that same row and replace the contents of UnitID in sheet: Tag_Log.<o></o>
How can this be done?
Thanks for your help.
Frank.