Re: [luau] Access2000 Linux import

2002-08-14 Thread Dean Fujioka
Don Brown wrote: {snip} Of course, you always could simply export all the data into csv or tab-delimited files and import. Don If you do this, I would use a character to delimit that does not occur in the database, ie a pipe | (hex 7c i think) or a semicolon... that way you won't lose as mu

Re: [luau] Access2000 Linux import

2002-08-14 Thread Ho'ala Greevy
I met with Scott last week at his firm's office in 1132 Bishop. The guy is going good Warren, he remembers you as well :-] He mentioned volume as the reason why he's not on LUAU anymore. -ho'ala Warren Togami said: > OMG! > > That guy was in my class in 6th grade. Around that time he convinced

RE: [luau] Access2000 Linux import

2002-08-13 Thread Brian Low
96817 Phone: (808) 371-3571 E-Mail: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Low Sent: Monday, August 12, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: [luau] Access2000 Linux import Aloha all, I current have a customer w

Re: [luau] Access2000 Linux import

2002-08-13 Thread Don Brown
>From what I've found: http://www.kofler.cc/mysql/mysql2mysql.html This script converts MS SQL Server 7/2000 to mysql. As mentioned you can import an access 2000 db into sql server by downloading the trial version of sql server. Found on the PHP builder message boards: "Just download MyODBC fro

[luau] Access2000 Linux import

2002-08-12 Thread W. Wayne Liauh
Brian- I am a minority owner of a company that does exactly what you described. They are developing and selling database packages (PostgreSQL + PHP) which can import Access 2000 files. If you couldn't find a local consultant, perhap you can give them a call. However, they can only take rela

Re: [luau] Access2000 Linux import

2002-08-12 Thread Warren Togami
On Mon, 2002-08-12 at 16:52, Ho'ala Greevy wrote: > Brian, > > might want to ping the folks at Indevtech Inc. Scott Cooley, former LUAU > member, runs the show over there. They developed hawaiieventsonline.com > > www.indevtech.com > [EMAIL PROTECTED] > 808-528-2

Re: [luau] Access2000 Linux import

2002-08-12 Thread Ho'ala Greevy
Brian, might want to ping the folks at Indevtech Inc. Scott Cooley, former LUAU member, runs the show over there. They developed hawaiieventsonline.com www.indevtech.com [EMAIL PROTECTED] 808-528-2740 -ho'ala Ray Strode said: >>

RE: [luau] Access2000 Linux import

2002-08-12 Thread Randall Oshita
>A few months ago I remember seeing an option in Microsoft SQL 2000's >Enterprise Manager that will easily import or export this type of data >between Access and MSSQL Server. I haven't used MSSQL for a few months >now, so I don't remember what this tool is called. You mean DTS? Data Transformati

Re: [luau] Access2000 Linux import

2002-08-12 Thread Ray Strode
> 1) I there a way to create a SQL database in linux and import the Access2000 > Database? Yes, there are many ways. You could transfer it through ODBC, or export it to some text format. I don't if there are any utilities to fully automate it (Maybe gnome-db?), but it should be a pretty small j

Re: [luau] Access2000 Linux import

2002-08-12 Thread Don Brown
Probably the easiest way would be to register the access database as an odbc datasource. You can then either use the web scripting language of your choice to make a web front end, or use the scripting language of your choice to pull out the data and stuff it into a mysql db or something of that na

Re: [luau] Access2000 Linux import

2002-08-12 Thread Warren Togami
On Mon, 2002-08-12 at 15:03, Brian Low wrote: > Aloha all, > I current have a customer with a Microsoft Access2000 Database. I > have 3 questions, 1) I there a way to create a SQL database in linux and > import the Access2000 Database? Probably the easiest way would be to export the data to Mic

[luau] Access2000 Linux import

2002-08-12 Thread Brian Low
Aloha all, I current have a customer with a Microsoft Access2000 Database. I have 3 questions, 1) I there a way to create a SQL database in linux and import the Access2000 Database? 2) IF it is posible, is there a way to build a Web base front end for the Database, and 3) Are there any local con