Trouble Importing from spreadsheet

mkamesh <[email protected]> Mon, 18 Jan 2010 18:55:47 -0800 (PST)
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
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

-- 
View this message in context: http://old.nabble.com/Trouble-Importing-from-spreadsheet-tp27220318p27220318.html
Sent from the openoffice - dba users mailing list archive at Nabble.com.