john3j
05-29-2009, 08:52 AM
Hey guys,
I have a MS Database that is linked to tables in sharepoint. In Sharepoint I have about 30 people whose names are reverted to numbers when pulled into Access, and Excel. Each person is directly related to an ID number, and that is what is being displayed in Excel, instead of the persons name. I dont know why or where the data is being reverted to the persons ID number through the process, but I need the names to display. I had an idea to create a select case that would do the following:
Find the last row in the sheet to set the range.
Go through three specified Columns, we will say F, G, and AB
From there change the text to the persons name depending on the ID number diplayed in each cell of each column.
I dont know if this is the best way to fix this problem, but if anyone has any ideas, please let me know. Also if anyone could help me write the code for the select case it would be great!
Thanks,
John:dunno
I have a MS Database that is linked to tables in sharepoint. In Sharepoint I have about 30 people whose names are reverted to numbers when pulled into Access, and Excel. Each person is directly related to an ID number, and that is what is being displayed in Excel, instead of the persons name. I dont know why or where the data is being reverted to the persons ID number through the process, but I need the names to display. I had an idea to create a select case that would do the following:
Find the last row in the sheet to set the range.
Go through three specified Columns, we will say F, G, and AB
From there change the text to the persons name depending on the ID number diplayed in each cell of each column.
I dont know if this is the best way to fix this problem, but if anyone has any ideas, please let me know. Also if anyone could help me write the code for the select case it would be great!
Thanks,
John:dunno