From: rr <emi...@ho...> - 2001-02-17 16:16:41
|
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 > > > |