Re: Access export overflow

I don't know what the problem is, but I would suspect
some weirdness in Access.

For exporting from Access to PostgreSQL, I suggest you
take a look at the "Database Migration Wizard" that
comes with PgAdminII (but not yet PgAdminIII,
regrettably).  I have had good experiences using that
wizard, which transparently does things like creating
appropriate sequences for your "autonumber" columns,
and creating referential integrity relationships based
on your Access setup.

http://www.pgadmin.org/pgadmin2/downloads/

--- Ken-ichi <kueda@nature.berkeley.edu> wrote:

> Hi folks.  I tried searching this list's archives
> for this problem but
> came up short.  I have a fairly large table in MS
> Access 2000 (33 cols,
> 3270 rows) that I'm trying to export to PostgreSQL
> 7.4.3.  When I clip
> the table to only about 100 rows, the export runs
> fine, but when I try
> to export the whole thing, I get an error window
> that says only
> "Overflow."  This process generates the following
> error in my
> postgresql.log file:
>
> ERROR:  relation "msysconf" does not exist
>
> The psqlodbc_xxxx.log written to my local machine
> ends with
>
> conn=124694520, query='ROLLBACK'
> conn=124694520, query='DROP TABLE "plot_data"'
> conn=124694520, PGAPI_Disconnect
>
> And the mylog_xxxx.log file doesn't seem to mention
> overflow anywhere,
> but it does contain the lines
>
> [1900]**** PGAPI_ExecDirect: hstmt=131080744,
> statement='DROP TABLE
> "plot_data"'
> [1900]PGAPI_ExecDirect: calling PGAPI_Execute...
> [1900]PGAPI_Execute: entering...
> [1900]PGAPI_Execute: clear errors...
> [1900]recycle statement: self= 131080744
> [1900]Exec_with_parameters_resolved: copying
> statement params:
> trans_status=1, len=22, stmt='DROP TABLE
> "plot_data"'
> [1900]   stmt_with_params = 'DROP TABLE "plot_data"'
> [1900]      it's NOT a select statement:
> stmt=131080744
> [1900]send_query(): conn=131086712, query='DROP
> TABLE "plot_data"'
> [1900]send_query: done sending query
>
> Can anyone tell me what's going on, and how to fix
> it?
>
> Thanks.
>
> -Ken-ichi
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>




__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail