tournament1 Posted March 13, 2008 Share Posted March 13, 2008 I would like to use a field imported from Excel and use it to look up the primary ID of that field. I have an Excel spreadsheet with 2 fields: ProjectID and Task Code. I would like to import the data into my Tasks_Projects table that has ProjectID, but doesn't have Task Code. Instead it has Task ID. Task_Projects table is linked to Tasks table by Task ID. Tasks is the table that has Task Code. How do I get the Tasks::Task ID assosiated with the Task Code in the Excel Spreadsheet? Thanks. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.