Populating a SP list from a flat file

[runnerlk]

I have a client that has created an HR repository using WSS 3.0.
He has created an employee list and manually enter some of the employees. The company's HR application is hosted off site, so the client is asking how to automate the daily import of a flat file to the HR list in SP. Is this something that could be done by creating a SQL Server DTS Package and importing to a single table?

 

[ehaze]

I'm using this to load data into SharePoint:

http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

Yes, you could use SQL Server to load data into SharePoint, but it's highly discouraged by Microsoft.

You can also use PowerShell.
Or even Access.

http://www.sharepointed.com/

 

[runnerlk]

Interesting, so I could use MS Access to load a text file into SQL Server and populate a SP list? But shouldn't use SQL Server import utility?

 

[ehaze]

Access can connect directly to the SharePoint List.

Access 2010:
External Data tab --> Import and Link section --> More --> SharePoint List.

Create a link to your List and try adding a few values.


If possible, stay away from loading data into the SharePoint SQL database...

http://www.sharepointed.com/

 

[runnerlk]

Thanks just what i needed.