Re: [GENERAL] import data from openoffice Calc

2009-12-02 Thread Le-shin Wu
table. For this case, I can not convert my original "date" data to text (because it will become an integer after converting as you mentioned). Thanks again. LW On Tue, Dec 1, 2009 at 6:38 PM, Adrian Klaver wrote: > > - "Le-shin Wu" wrote: > > >

Re: [GENERAL] import data from openoffice Calc

2009-12-01 Thread Le-shin Wu
works for only once. This also confused me. Thanks again. LW On Tue, Dec 1, 2009 at 11:04 AM, Adrian Klaver wrote: > On Tuesday 01 December 2009 7:40:26 am Adrian Klaver wrote: > > On Tuesday 01 December 2009 7:21:45 am Le-shin Wu wrote: > > > Hi, > > > > > >

[GENERAL] import data from openoffice Calc

2009-12-01 Thread Le-shin Wu
Hi, I use OpenOffice Base as the front end tool to connect a postgreSQL server. It works great. But when I am trying to create a table by copying data from OpenOffice Calc and then pasting to my postgreSQL database (connected through OpenOffice base), I always got an invalid input syntax error for