hi,
what's the error message you get ? is it "Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine" ??
since it's working on local and not on the server, and Office 2007 is installed on your server, probably it's a 32/64bits problem.
the obvious guess is that your your server is 64bit and your local system is 32bits,
follow this tutorial
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine to make Jet OLEDB run on a 64bits machine.
hope this helps.