sql-ledger-users

Re: [SQL-Ledger-users] DOCUMENTATION

[Thomas S. <ps...@on...>]

Finally but not least...

I wrote a Visual Basic program called SQL Post which will take a Microsoft
Access Table and translate it into a set of insert statements and save
them to a .sql file. This makes it easy to move Access data to Postgresql.
(That's how I loaded my 25,000+ inventory records!) I upload it to ZDNet
so it should be available there is a week or so. If anyone would like
a copy of it sooner let me know, I can email attach it to them (it's
only 88k in size).

-- 
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

RE: [SQL-Ledger-users] DOCUMENTATION

[Ing. A. A. G. <ag...@ma...>]

Good job!

We have currently enhanced an Upsizing Tool from MS Access to =
PostgresSQL
7.0.3 the Tool in question will be posted in the next days after
confirmation from his author to them them on a sourgeforce project.

The tool transfer structure an d data from Access to Postgres.

Regads,

Antonio Gallardo.



-----Mensaje original-----
De: sql...@li...
[mailto:sql...@li...]En nombre de =
Thomas
Sawyer
Enviado el: S=E1bado, 03 de Febrero de 2001 05:49 p.m.
Para: sql...@li...
Asunto: Re: [SQL-Ledger-users] DOCUMENTATION


Finally but not least...

I wrote a Visual Basic program called SQL Post which will take a =
Microsoft
Access Table and translate it into a set of insert statements and save
them to a .sql file. This makes it easy to move Access data to =
Postgresql.
(That's how I loaded my 25,000+ inventory records!) I upload it to =
ZDNet
so it should be available there is a week or so. If anyone would like
a copy of it sooner let me know, I can email attach it to them (it's
only 88k in size).

--=20
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] DOCUMENTATION

[Thomas S. <ps...@on...>]

Anyone interested in the following, read below, I have good news:

> I wrote a Visual Basic program called SQL Post which will take a Microsoft
> Access Table and translate it into a set of insert statements and save
> them to a .sql file. This makes it easy to move Access data to Postgresql.
> (That's how I loaded my 25,000+ inventory records!) I upload it to
> ZDNet
> so it should be available there is a week or so. If anyone would like
> a copy of it sooner let me know, I can email attach it to them (it's
> only 88k in size).

The good news is:

You don't need this program if you have MS Access. Rather, simply install
the Postgresql ODBC driver and use Access to File/Export your table to
the ODBC source. Wooshh...There's your table and all its data. :)

Yet my program may be useful in other ways, and I plan to expand it to
do more and work with other data stores.

-Thomas Sawyer

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] ODBC , Windows , Linux

[rr <emi...@ho...>]

I noticed that you are using Visual Basic with Postgres .  Do you need the
ODBC driver installed on the Windows machine and the Linux server ?

----- Original Message -----
From: Thomas Sawyer <ps...@on...>
To: <sql...@li...>
Sent: Saturday, February 17, 2001 7:06 AM
Subject: Re: [SQL-Ledger-users] DOCUMENTATION


> Anyone interested in the following, read below, I have good news:
>
> > I wrote a Visual Basic program called SQL Post which will take a
Microsoft
> > Access Table and translate it into a set of insert statements and save
> > them to a .sql file. This makes it easy to move Access data to
Postgresql.
> > (That's how I loaded my 25,000+ inventory records!) I upload it to
> > ZDNet
> > so it should be available there is a week or so. If anyone would like
> > a copy of it sooner let me know, I can email attach it to them (it's
> > only 88k in size).
>
> The good news is:
>
> You don't need this program if you have MS Access. Rather, simply install
> the Postgresql ODBC driver and use Access to File/Export your table to
> the ODBC source. Wooshh...There's your table and all its data. :)
>
> Yet my program may be useful in other ways, and I plan to expand it to
> do more and work with other data stores.
>
> -Thomas Sawyer
>
> __________________________________________________
> FREE voicemail, email, and fax...all in one place.
> Sign Up Now! http://www.onebox.com
>
>
>

Re: [SQL-Ledger-users] DOCUMENTATION

[Mitterwald, H. <mit...@co...>]

Thomas Sawyer wrote:
[..]
> 
> The good news is:
> 
> You don't need this program if you have MS Access. Rather, simply install
> the Postgresql ODBC driver and use Access to File/Export your table to
> the ODBC source. Wooshh...There's your table and all its data. :)

You have to be careful with Access. I used it until I found out that
Access
added an empty row to all tables that used OIDs as primary key. Grmbl. 

Best regards,
   Holger Mitterwald