Viewing 4 posts - 1 through 4 (of 4 total)
I have no idea. I am working on getting the client to upgrade to SQL server 2005 standard and then I can use SSIS integration to create the packages and...
February 27, 2007 at 6:29 am
Try this:
In Management Studio you expand the "Server Objects" and then expand "Linked Servers".
Right-Click "Linked Servers" to add a new linked server.
February 23, 2007 at 10:50 am
TRY THIS:
Execute sp_addlinkedserver to create the linked server, specifying Microsoft.Jet.OLEDB.4.0 as provider_name, and the full path name of the Access .mdb database file as data_source. The .mdb database file must...
February 23, 2007 at 10:23 am
Does the database exist in SQL 2005 or do you want to import the Access database into a sql database?
February 23, 2007 at 9:38 am
Viewing 4 posts - 1 through 4 (of 4 total)