Re: Create Oracle table from Access97

Ken Nowinski (nowinski_at_telephonics.com) wrote:
: 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!

This sounds like a problem with data type mismatch between access and oracle. If you check out the data type of the table in Access and then in Oracle and compare them, they should be the same (or at least the appropriate equivalent

date = date/time
varchar = text
number = number

or some such thing...

I think that Access will give you an error table or something like that in this situation telling you which row and maybe column had a problem and what that problem was. You also may want to look at the data in the Access tables. I've had instances where I imported data into access, it got boged along the way and looks like #num in access and then it won't append into Oracle. See if you have any of that, but otherwise change your oracle or access datatypes so that they match and you should be taken care of.

HTH,
Greg Received on Wed Aug 22 2001 - 10:37:45 CDT