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 >