Total beginner querying oracle tables

From: Bonnie R <bonvig_at_aol.com>
Date: 11 Feb 2003 17:57:26 -0800
Message-ID: <72187104.0302111757.7536ccb0@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 - 19:57:26 CST