From: Thomas S. <ps...@on...> - 2001-02-17 15:06:06
|
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 |