M
mscertified
I need to export some data to a data warehouse. I cannot map a drive to it
but must logon with a userid and password. Is it possible to create a
'transfertext' to do this. I looked in Access Help and it says:
"Note You can also use ActiveX Data Objects (ADO) to create a link by using
ActiveConnection property for the Recordset object."
However, it gives no further details and no examples.
but must logon with a userid and password. Is it possible to create a
'transfertext' to do this. I looked in Access Help and it says:
"Note You can also use ActiveX Data Objects (ADO) to create a link by using
ActiveConnection property for the Recordset object."
However, it gives no further details and no examples.