export to access database [newbie]

Question

export to access database [newbie]

fergus davidson

Grasshopper

Points: 10
More actions
October 18, 2006 at 3:58 am

#69428

i have an sql database which i need to export to access 2000.
i have used the dts export successfully to export to a database here on my desktop.
what i need to do however, is to export to an access file on the same server so that the client can download the exported data in a format he can use.
my problem is that i can't figure out how t get the destination file to be one lying on the server.

can someone help me?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

hi

i may have not understood ur issue correctly. do u mean u want to export from a access2000 to another access2000 or from sql server to access2000. if its from sql to access then import export wizard or dts shud do.

"Keep Trying"

fergus davidson Grasshopper Points: 10 More actions · Answer 2

sorry if i wasn't clear

i need to export from SQL to access

the problem i have is in defining the destination. i want to export to an access database on the hosting server.

import/export seems to allow me to export only to my own pc

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

hi

i was able to export data from sql to a access file residing on another machine in the local network using import export.

hope this helps ........ and iam sorry if it does'nt

"Keep Trying"

Matt Simmons SSCrazy Points: 2846 More actions · Answer 4

If I remember correctly the issue with this is that the SQLAdmin account needs to have write access to the drive/folder on the server where you want to place the exported access file. Once that is setup correctly you should be able to use a UNC path (\\ServerName\FolderName\Subfolder) as the export path.

Hope that helps.

Regards,
Matt