Re: 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