lost the SFDATA. in the query
and try that although the into testtable might not work, try just select.
Why download it locally?
Jim
"Bonnie R" <bonvig_at_aol.com> wrote in message
news:72187104.0302111757.7536ccb0_at_posting.google.com...
> Hello, This is probably screechingly obvious, but I'm stumped. I've
> hunted through all these groups for the answer, but it eludes me.
>
> I am using ado from vba to connect to oracle tables to run an insert
> into query to download the oracle table locally:
>
> ==================
> Set adoRS = CreateObject("ADODB.RecordSet")
> Set adoConn = CreateObject("ADODB.Connection")
> adoConn.Open "PROVIDER=MSDAORA.1;Data Source=xxxx;User
> ID=xxxx;Password=xxxx;"
>
> sSql = "SELECT SFDATA.AHVZPER_PER_D.EMPLOYEE_ID,
> SFDATA.AHVZPER_PER_D.EMP_NAME, SFDATA.AHVZPER_PER_D.BIRTH_DATE,
> SFDATA.AHVZPER_PER_D.SPOUSE_NAME INTO TESTTABLE FROM
> SFDATA.AHVZPER_PER_D ;"
>
> Set adoRS = adoConn.Execute(sSql)
>
> ============
> When I run this, I get an error: ORA-00905: missing keyword
>
> I've tried many different iterations, and nothing is helping. I
> suspect it's something so obvious it's not even documented, or else
> it's just plain wrong.
>
> Thanks for any direction anyone can provide!
> Bonnie
Received on Tue Feb 11 2003 - 20:02:27 CST
