I'm running sql in vba, doing a simple select/from, but the table name is 35 characters long.
I'm working in access 2010 and have a table linked to an oracle db.
The table name, before importing, was (10char).(25char)
After importing, access named it to (10char)_(25char) or (35char)
Basically, the table name before importing was listed as "edw_prod.mth_customer_coverage_plan " during the link table wizard, and after linking it was named "edw_prod_mth_customer_coverage_plan " in access.
Here's my code:
tmpStr = "SELECT inquiry_cov_src_cust_id, src_cust_id " & _
"FROM ccp_service_ccp_inquiry c, edw_prod_mth_customer_coverage_plan p " & _
"WHERE c.inquiry_cov_src_cust_id = p.src_cust_id " & _
"AND p.cov_plan_eff_date > '1/1/2010';"
adoCmd.CommandText = tmpStr
Set adoData = adoCmd.Execute
In my sql statement, am I to refer to the table by it's full length or after the period? This is my first time linking an oracle table via access.