Import from secured Access Database

Question

Import from secured Access Database

Allen Cui-55137

SSC Guru

Points: 51650
More actions
October 23, 2002 at 2:46 pm

#105178

Please advise how to import data from a secured Access 97 database into SQL Server using DTS. The Access database has password set and users have to login into it from a mdw file.

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

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

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 1

Do a database import. Choose the Data Source Type to "Microsoft Access", select the aceess .MDB file. set the user name and paswword. Similary specify the destination to SQL server. That should do it.

Venky

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 2

It is a secured Access database. Your procedure just doesn't work.

stuartradcliffe SSC Veteran Points: 231 More actions · Answer 3

This works for me:

1. Right Click on Data Transformation Services and select Import Data.

2. Select Data Source to Microsoft Access.

3. In File Name enter the full path to the Access database.

4. In username enter the username that you would normally use to log on to the Access application.

5. In Password enter the password that you would normally use to log on to the Access application.

6. Click Advanced.

7. In the Value for the Property "Jet OLEDB:System database" type in the full path and file name of the system.mdw file that your Access application uses.

8. Click OK, then click Next.

9. Continue as you would for a normal DTS Import.

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 4

Thanks. It works now.

Have you configured Secured Access Database as a Linked Server?

Edited by - Allen_Cui on 10/24/2002 08:51:30 AM