>Based on my research a command of this type should work to import data from an Access database.
>
>insert into LookupFundTypes (FundType)
>select fundtype
>from opendatasource ('Microsoft.Jet.OLEDB.4.0','D:\tipconversion.mdb')...fundtypes
>
>However when I run it I get an error:
>Msg 7403, Level 16, State 1, Line 6
>The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
>
>I have win7 32 bit and sqlserver 2008 R2 installed.
>Can someone suggest a solution?
>Alternatively, is there an opendatasource command that will work with VFP database tables? That would be even better.
>
>Thanks
Do you have the OleDB installed on that machine?
In addition, I think this blog may help
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/ace
If it's not broken, fix it until it is.
My Blog