Re: [luau] Access2000 Linux import
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 much data by creating extra fields whenever and wherever there are commas,,, and tabs. ;) dean
Re: [luau] Access2000 Linux import
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 > me that a 486 DX/2 66MHz is so much cooler than an Apple Quadra. I > almost made a grave mistake of buying a Mac. > > This list, group, and everything we have here today would be DEAD right > now if it wasn't for this jack ass. > > Anyone talk to Scott Cooley? I must thank him for his lame dial-up BBS > with color ANSI graphics demo back in 6th grade. That one demo saved > me from what was potentially the worst decision in my life. Had I > bought that Mac, I would have probably never began to learn Linux a > year later. > > I wonder if he would join the mailing list. I notice that his web > sites appear to be Linux and PHP. Awesome. > > > > ___ > LUAU mailing list > [EMAIL PROTECTED] > http://videl.ics.hawaii.edu/mailman/listinfo/luau
RE: [luau] Access2000 Linux import
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 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 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 consultants that are intrested in working on this project? Thanks, Brian Brian Low Security X 1515 Nuuanu Ave. #555 Honolulu, HI 96817 Phone: (808) 371-3571 E-Mail: [EMAIL PROTECTED] ___ LUAU mailing list [EMAIL PROTECTED] http://videl.ics.hawaii.edu/mailman/listinfo/luau <>
Re: [luau] Access2000 Linux import
>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 www.mysql.com Then open your Access2000 and export data. Select ODBC databases from the "Save-As-Type" dropdown-list and select your MySQL database (if you have given it a Windows DSN name - if not create a new one) Good luck. Don
Re: [luau] Access2000 Linux import
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 > > > -ho'ala OMG! That guy was in my class in 6th grade. Around that time he convinced me that a 486 DX/2 66MHz is so much cooler than an Apple Quadra. I almost made a grave mistake of buying a Mac. This list, group, and everything we have here today would be DEAD right now if it wasn't for this jack ass. Anyone talk to Scott Cooley? I must thank him for his lame dial-up BBS with color ANSI graphics demo back in 6th grade. That one demo saved me from what was potentially the worst decision in my life. Had I bought that Mac, I would have probably never began to learn Linux a year later. I wonder if he would join the mailing list. I notice that his web sites appear to be Linux and PHP. Awesome.
Re: [luau] Access2000 Linux import
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: >> 3) Are there any local consultants that are intrested in working on >> this project? > Don't know about this one.
RE: [luau] Access2000 Linux import
>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 Services. It should do the trick. Randall
Re: [luau] Access2000 Linux import
> 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 job to script. > 2) IF it is posible, is there a way to build a Web base front end for the > Database, Yup. PHP/MySQL is a pretty common combination for doing such things. http://www.php.net and http://www.mysql.org respectively. > 3) Are there any local consultants that are intrested in working on > this project? Don't know about this one. --Ray
Re: [luau] Access2000 Linux import
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 nature. Of course, you always could simply export all the data into csv or tab-delimited files and import. Don On Mon, 12 Aug 2002, 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? 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 > consultants that are intrested in working on this project? > > Thanks, > Brian > > Brian Low > Security X > 1515 Nuuanu Ave. #555 > Honolulu, HI 96817 > Phone: (808) 371-3571 > E-Mail: [EMAIL PROTECTED] > ___ > LUAU mailing list > [EMAIL PROTECTED] > http://videl.ics.hawaii.edu/mailman/listinfo/luau >
Re: [luau] Access2000 Linux import
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 Microsoft SQL syntax, then do some manual regex conversion of that text to get it into PostgreSQL or MySQL syntax. Ryan Shrout, owner of AMDMB needed to do just this a while ago when he converted from Windows 2000, IIS web server, MSSQL and ColdFusion to LAMP (Linux, Apache, MySQL, PHP), so I know this is very possible. 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 could either use the Microsoft SQL 2000 120-day demo in order to help convert the data, or perhaps Access 2000 has its own "export to SQL" option. There may also be Open Source tools that can input Access databases. I will search around. > > 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 > consultants that are intrested in working on this project? > > Thanks, > Brian Definitely. There are many local people that can do this well. I personally don't have the time (and I would be very slow at doing it), but contact me directly and I'll have some recommendations for people who could possibly do the job within a day or two. Warren