Using Excel 2010 to input information into SQL Server 2008

[lilal111]

I was asked if it is possible to use Microsoft Excel to input information into a table in SQL Server 2008. We have a Project Manager that is trying to use Excel as an interface to populate Assigned Hours and Estimated Hours.

Any help would be so appreciated!!

Thanks!!

 

[jrbarnett]

Use VBA (with ADO for the database connectivity) or one of the .Net languages and Visual Studio Tools for Office in your Excel spreadsheet to connect to the database. Through there you can run your stored procedures to manipulate the data as appropriate.

The VBA or Microsoft Office forums will be better placed to advise on coding and reading data from Excel to SQL Server than this one.

John

 

[simian336]

The bad thing about Excel is that you cannot (easily) control the data that is being entered. So it is easier to get data type conflicts and errors.

Simi