D
dsrweat
I have set up a daily import using Access 2007 of an excel spreadsheet
through a linked table. I created the list in Sharepoint with a total of 7
fields and have problems importing data into two of them.
The first is the techid field which is a lookup field that pulls data from
the User Information List from a field called techid that is populated
whenever a new user is added. The second is techname that is a person or
group lookup that shows all users.
After running the import, nothing shows in Sharepoint for those two
particular fields but the rest of the fields have the imported data in them.
I look back at Access and the data is there. I can also go to the fields in
Access and the lookups from the User Information List show up in the drop
down.
What I'm trying to achieve is the same result as if I had keyed the data
into Sharepoint itself. After the record is created, I need to be able to
click on techid or techname and it link me back to the user profile. I also
want to set up a view in this list that only shows records where techname is
equal to [me] which I can do once the import works correctly.
I've been chasing Sharepoint thinking that is where the problem is but I'm
beginning to think it's a problem with the field in Access that may be
causing it. It seems that if I'm importing data into a field that matches
what is in the lookup field, it should do the link.
I created both a lookup field and a person or group field in Sharepoint and
they both show the recordid from the user information list when I view them
in Access. If I put the recordid in my Excel spreadsheet and do the import,
the name shows up in Sharepoint.
This is the lookup that Access is doing for the techid field:
SELECT [ID], [TechID] FROM [User Information List] ORDER BY [TechID];
This is the lookup for the techname field:
SELECT [ID], [Name] FROM [User Information List1] ORDER BY [Name];
through a linked table. I created the list in Sharepoint with a total of 7
fields and have problems importing data into two of them.
The first is the techid field which is a lookup field that pulls data from
the User Information List from a field called techid that is populated
whenever a new user is added. The second is techname that is a person or
group lookup that shows all users.
After running the import, nothing shows in Sharepoint for those two
particular fields but the rest of the fields have the imported data in them.
I look back at Access and the data is there. I can also go to the fields in
Access and the lookups from the User Information List show up in the drop
down.
What I'm trying to achieve is the same result as if I had keyed the data
into Sharepoint itself. After the record is created, I need to be able to
click on techid or techname and it link me back to the user profile. I also
want to set up a view in this list that only shows records where techname is
equal to [me] which I can do once the import works correctly.
I've been chasing Sharepoint thinking that is where the problem is but I'm
beginning to think it's a problem with the field in Access that may be
causing it. It seems that if I'm importing data into a field that matches
what is in the lookup field, it should do the link.
I created both a lookup field and a person or group field in Sharepoint and
they both show the recordid from the user information list when I view them
in Access. If I put the recordid in my Excel spreadsheet and do the import,
the name shows up in Sharepoint.
This is the lookup that Access is doing for the techid field:
SELECT [ID], [TechID] FROM [User Information List] ORDER BY [TechID];
This is the lookup for the techname field:
SELECT [ID], [Name] FROM [User Information List1] ORDER BY [Name];