Re: Trouble Importing from spreadsheet

John Meyer <[email protected]> Mon, 18 Jan 2010 20:04:02 -0700
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Just to get this clear, you are talking about an Apache Derby database, 
is that correct?


On 1/18/2010 7:55 PM, mkamesh wrote:
>
> Hi
> I am an absolute beginner trying to learn a few things and get some work
> done.
>
> I have a Derby database and am desperately trying to append/import hundreds
> of products into an existing table in ooBase. However I am facing error
> messages like the import trying to insert Varchar in a Blob column, and if I
> ask to not import that column  it says it fails to create the primary key
> which is a UUid . The option to generate UUid appears grayed out in the
> import screen. OObase tries importing a single line and then quits.
>
> Can somebody advice me what am I missing here..
>
> Thanks in advance.
>
> Kamesh
>