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 -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
