I am looking for a way to maintain a SharePoint list of employees and their employee ID. I have the data in SQL and would like to get it into a list to use as a look up. I do not have access to a BDC.

Thanks

• sharepoint

Write an SPTimerjob that runs daily / weekly, updating / adding data from SQL to the list. Here's a link to a primer on custom timerjobs.

Andrew Connell's blog

Do you want to duplicate your data inside SharePoint or just want a way to view it? You can just create a custom web part or use a 3rd party tool such as Data Viewer Web Part

Regards,

Phill