Thanks Greg for your response. Sorry to have taken so long to
acknowledge, but I had an out-patient medical procedure that led to an
in-patient situation but all is well now. When I run my append query
Access97 prompts "You are about to append 17 rows" and then I click
"Yes". Then I am promted with "Microsoft Access can't append all the
records in the append query" -- "Microsoft Access set 17 field(s) to
Null due to a type conversion failure....." Your last question
alludes to the fact that I may have a rights issue. Are you asking if
the user (myself) has write access to the Oracle database? Thanks
again!
gregoryk_at_futures.wharton.upenn.edu (GREGORY KNESER) wrote in message news:<9leo6h$gvs$1_at_netnews.upenn.edu>...
> Does Access give you any error messages? Do you hit "Yes" when Access
> asks if you are sure that you want append the rows? Does the user that
> you are connecting to the Oracle database with have the permission to do
> an insert query?
>
> I do what you describe below on a weekly if not daily basis and it works,
> so you can definitely do it.
>
> Good luck,
> Greg
>
> Ken Nowinski (nowinski_at_telephonics.com) wrote:
> : Is it possible to export an Access97 table to Oracle? I created the
> : table in Oracle, a link to the Oracle table and then wrote an append
> : query to populate it in Oracle. When query is run, no records get
> : saved to the Oracle table. What must I do to make this work? All
> : comments are greatly appreciated! Thanks!
Received on Mon Aug 20 2001 - 14:01:16 CDT
