Just tried it here with XP Same situation - with one very odd thing
I made the table ID, identity one, CHAR(5) Two, CHAR(5) Three, NUMERIC Four, NUMERIC then in a calc file I created three rows ID ONE TWO THREE FOUR 0 BOB TED 1 2 1 SMITH CAROL 7 8 2 12345 BOB 4 100 3 1234 123 10 -1 Formated columns ONE and TWO as TEXT - then copied them and pasted them into the table in the database. Here is what I get in Base ID one two three four 0 0 0 1 2 1 0 0 7 8 2 12345 0 4 100 3 1234 123 10 -1 Looks like you are on the way to Issue Tracker... On 9/29/07, Regina Henschel <[EMAIL PROTECTED]> wrote: > Hello, > > Regina Henschel schrieb: > > Hello, > > > > I've got a database table with "text(fix), field width 2 characters" as > > primary key. If I try to append data from a Calc table, the wizard > > writes a 0 into the primary field (and appending fails therefore). The > > other values are written correct. > > I have to correct me. Another "text(fix), field width 3 character" is > also set to 0. > > kind regards > Regina > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
