Hello, I have a Database called My Travel Project which I am trying to export to an Access Database called
Travel Project Imported.
I right clicked on the My Travel Project Database in Sql and chose Export.
When the wizard opened I chose Microsoft OLE DB Provider for Sql Server as a Data source
but I am not sure if this is the correct option to choose and chose Windows Authentication.
I was then asked to choose a Destination. I tried Microsoft Access(Microsoft Jet Database Engine)
and put in Travel Project Imported as the file name of the Access database.
When I clicked next I got an error message
Can anyone help with how to Export this Database correctly?
Thank you
...
Go to the complete details ...