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:[EMAIL PROTECTED]] > Sent: 29 April 2002 20:49 > To: Dave Page; [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> wrote: > > > > > > > -----Original Message----- > > > From: Keehan Mallon [mailto:[EMAIL PROTECTED]] > > > Sent: 29 April 2002 17:48 > > > To: [EMAIL PROTECTED] > > > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
