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