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-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

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 from

RE: [luau] Access2000 Linux import

2002-08-13 Thread Brian Low
Aloha all, Thanks for all your help. I talked to Charles Paul on a sub-contact deal. I will keep all your e-mail's for future reference. This has helped me and my sister company (PG Enterprises out a ton :) Thanks Again, Brian Brian Low Security X 1515 Nuuanu Ave. #555 Honolulu, HI 96817

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

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

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

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 Transformation

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 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-2740