Re: Error in Database Migration Wizard with Acc

Hi Keehan,

The log looks odd, there are no datatypes specified for any of the columns!
Can you please check there are valid mappings on the 'Type Map' and try
again - if it still doesn't work, can you send me a copy of the Access db
please?

As for the logfile, check under Tools -> Options. On the Logging tab you can
specify a logfile.

Regards, Dave.

> -----Original Message-----
> From: Keehan Mallon [mailto:keehan_mallon(at)yahoo(dot)com]
> Sent: 29 April 2002 20:49
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> Subject: RE: [pgadmin-support] Error in Database Migration
> Wizard with Acc ess DB
>
>
> Sure thing Dave!
>
> I got the output from the log window. Here it is.
>
> Is there a log file that I can grab this stuff from??? I
> don't seem to find one???
>
> Thanks for your help this is driving me nuts. I have seen
> other parsing errors as included in my original e-mail.
>
> Cheers,
>
> Keehan
>
>
>
>
>
>
> --- Dave Page <dpage(at)vale-housing(dot)co(dot)uk> wrote:
> >
> >
> > > -----Original Message-----
> > > From: Keehan Mallon [mailto:keehan_mallon(at)yahoo(dot)com]
> > > Sent: 29 April 2002 17:48
> > > To: pgadmin-support(at)postgresql(dot)org
> > > Subject: [pgadmin-support] Error in Database Migration Wizard
> > > with Access DB
> > >
> > >
> > > Hello list,
> > >
> > > I'm having a problem importing an Access DB into PG using the
> > > Database Migration Wizard Plugin for PgAdmin II.
> > >
> > > I can see the Access DB, select it, choose tables (or a
> > > single table), tell it to import the data, select foreign
> > > keys (or not with only a single table) and then tell it to
> > > migrate. I get an error immediately after starting the migration:
> > >
> > > Creating table: CustomerReturn
> > >
> > > An error occured at: 4/29/2002 9:03:04 AM:
> > > -2147467259: Error while executing the query;
> > > ERROR: parser: parse error at or near "PRIMARY"
> > >
> > > Rolling back... Done.
> > >
> > > Looking at the log file, it looks like it is barfing trying
> > > to parse the query.
> >
> > Can you post a logfile with the SQL in it please?
> >
> > Regards, Dave.
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - your guide to health and wellness
http://health.yahoo.com