Re: [GENERAL] Access to postgres conversion

2011-06-02 Thread akp geek
The only problem I am seeing with dates as you mentioned. when I export the data to csv the date is getting the format of 8/1/1955 0:00:00 , but postgres not accepting that. Any clues? Regards On Thu, Jun 2, 2011 at 11:23 AM, Vick Khera wrote: > On Thu, Jun 2, 2011 at 10:01 AM, akp geek wrote:

Re: [GENERAL] Access to postgres conversion

2011-06-02 Thread Vick Khera
On Thu, Jun 2, 2011 at 12:01 PM, akp geek wrote: > The only problem I am seeing with dates as you mentioned. when I export the > data to csv the date is getting the format of 8/1/1955 0:00:00 , but > postgres not accepting that. Any clues? Should work: test=> select '8/1/1955 0:00:00'::date;

Re: [GENERAL] Access to postgres conversion

2011-06-02 Thread Vick Khera
On Thu, Jun 2, 2011 at 10:01 AM, akp geek wrote: > Thanks so much . I was using bullzip What I felt with Bullzip was it is good > for less amount of data.  I have 2 tables each of which has 2.5 million > records.  For me it is taking for ever, The job that I set up has been > running since 12 hour

Re: [GENERAL] Access to postgres conversion

2011-06-02 Thread akp geek
Thanks so much . I was using bullzip What I felt with Bullzip was it is good for less amount of data. I have 2 tables each of which has 2.5 million records. For me it is taking for ever, The job that I set up has been running since 12 hours. I appreciate if you could share the VBA code that you

Re: [GENERAL] Access to postgres conversion

2011-06-02 Thread Thomas Harold
On 5/25/2011 3:42 PM, akp geek wrote: Dear all - I would like to know if any one has migrated database from MS access to Postgres . We use postgres 9.0.2 on solaris . Are there any open source tools that you have used to do this task. Can you please share your experiences ? I rol

Re: [GENERAL] Access to postgres conversion

2011-05-26 Thread Jasen Betts
On 2011-05-25, akp geek wrote: > --000e0cd22f6cd3829104a41ee636 > Content-Type: text/plain; charset=ISO-8859-1 > > Dear all - > > I would like to know if any one has migrated database from MS > access to Postgres . We use postgres 9.0.2 on solaris . Are there any open > source tools t

Re: [GENERAL] Access to postgres conversion

2011-05-25 Thread Tommy
Hi. You could try /Access to PostgreSQL /from Bullzip.com. I liked the dump file that this creates. Small neat and it is free! Tommy. It's 10 tables. that's all. No reports. I will follow your suggestion. Thanks for the help On Wed, May 25, 2011 at 4:25 PM, John R Pierce

Re: [GENERAL] Access to postgres conversion

2011-05-25 Thread akp geek
It's 10 tables. that's all. No reports. I will follow your suggestion. Thanks for the help On Wed, May 25, 2011 at 4:25 PM, John R Pierce wrote: > On 05/25/11 12:42 PM, akp geek wrote: > >> Dear all - >> >>I would like to know if any one has migrated database from MS >> access to Po

Re: [GENERAL] Access to postgres conversion

2011-05-25 Thread John R Pierce
On 05/25/11 12:42 PM, akp geek wrote: Dear all - I would like to know if any one has migrated database from MS access to Postgres . We use postgres 9.0.2 on solaris . Are there any open source tools that you have used to do this task. Can you please share your experiences ? how

[GENERAL] Access to postgres conversion

2011-05-25 Thread akp geek
Dear all - I would like to know if any one has migrated database from MS access to Postgres . We use postgres 9.0.2 on solaris . Are there any open source tools that you have used to do this task. Can you please share your experiences ? Regards