Re: Trouble Importing from spreadsheet

mkamesh wrote:
> I have a Derby database and am desperately trying to append/import hundreds
> of products into an existing table in ooBase. 

Hello Kamesh,

Let me be sure that I understand also.

You have an existing Derby db with hundreds of records that you want to 
import into a Base embedded database - yes?

You currently have 2 Base odb files - yes?

One Base file connects to Derby via JDBC and the other is the embedded 
database.

You open both then drag a table object from the Derby connected Base 
file window to the other Base window to launch the import wizard - yes?

> 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

The varchar column is in the Derby database and the blob field is in the 
Base embedded database - is that right?

The UUid column has to be in the Derby database as Base's embedded 
database (HSQLdb) does not have that as a native data type.
So are you importing the actual UUid column data to a column in the 
embedded database of type Big Int and is the PK field for the table - yes?
The import column is defined as AutoIncrement?

If all of that is true then most likely the problem with the UUid (PK) 
sounds like a simple mistake your are making in the import wizard...I 
say simple cause it sounds like something I have done a bunch of time. 
The varchar, blob thing well...

Well, do you mind if I just ask your those questions first.

Thanks

Drew