Posted on: 12/13/2015 6:54:33 AM | Views : 2623

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 ...