I appreciated your first email, regardless of whether or not I was able to make it work. Any response is welcome! I am having some trouble with the final result using the CVS file: some of the content uses commas i.e. "Chinchilla Zúñiga, Guillermo" and gets split up between two fields. This whole process is pretty messy, but I'm sure I will find a solution. The tools I was directed to below at freshmeat.net are a little out of my league. I am a Macintosh user that programs in applescript, a little obj-C, and SQL. I don't know if I can even implement those classes.
Thanks! John on 7/8/04 6:11 AM, Chinchilla Zúñiga, Guillermo at [EMAIL PROTECTED] wrote: > I did it because I wrongly assummed this was obviuos, but then I resend to Mr. > Mistler a more precisely email. > > I´m sorry. > > Cheers > Guillermo > > -----Mensaje original----- > De: Joshua J. Kugler [mailto:[EMAIL PROTECTED] > Enviado el: Miércoles, 07 de Julio de 2004 05:37 p.m. > Para: [EMAIL PROTECTED] > Asunto: Re: DBF to MySQL > > I'm sure it did...DBF and XLS files are not plain text. What Chincilla gave > your was a bit of code for importing CSV files, after they had been exported > from Excel. I'm not sure *why* he gave you that code. > > You can do one of two things. 1) Open up those files in Excel (it will also > open DBF files) and export them as CSV, or 2) find a class and > programmatically import them (search freshmeat.net for 'dbf'). > > If you need more info, holler. > > j----- k----- > > On Tuesday 06 July 2004 07:55 pm, John Mistler said something like: >> For some reason, the imported information showed up as garbled nonsense. >> The file I was importing was an .xls file. Do you know if there is another >> "TERMINATED BY" I should be using? If not, I wonder how I can find out? >> >> The other question I have is: do I have to create a table within the MySQL >> database with exactly the right number of columns ahead of time for the >> import to work? - this is what I did. If so, is there a way to import info >> from a .dbf or .xls file without knowing the structure of the table ahead >> of time? >> >> Thanks, >> >> John >> >> on 7/6/04 3:59 PM, Chinchilla Zúñiga, Guillermo at [EMAIL PROTECTED] >> >> wrote: >>> Try, for example: >>> >>> LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable >>> FIELDS TERMINATED BY ',' ENCLOSED BY '"' >>> LINES TERMINATED BY '\n'; >>> >>> >>> -----Mensaje original----- >>> De: John Mistler [mailto:[EMAIL PROTECTED] >>> Enviado el: Martes, 06 de Julio de 2004 04:51 p.m. >>> Para: [EMAIL PROTECTED] >>> Asunto: DBF to MySQL >>> >>> I am wanting to parse the info in a .dbf file (or .xls file for that >>> matter) and place it in a table in a MySQL database. Is this something >>> that I can do with the server side MySQL application, or do I need to >>> figure out a way to do it on the client side? Any description of the >>> method would be very welcome! >>> >>> For what it is worth, I am a Mac OSX.3 user. >>> >>> Thanks, >>> >>> John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
