Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Connecting to Access Database in DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-10 : 08:09:05
Brian writes "I'm having a problem with a connection to an access database. I can select the tables i want to pull from in DTS Data Transform Task but i am not able to see the Field Names so that i can select which ones i want. I'm wondering if i need certain access permissions ( I already have read access) or if it is something on my SQL Server Side that is not allowing me to see the field names.

Thanks,
Brian"
   

- Advertisement -