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]
