Check out this page. You still have to create the table in mysql first, then you can run the LOAD DATA INFILE .... command .
http://www.mysql.com/doc/L/O/LOAD_DATA.html ----- Original Message ----- From: "Todd Williamsen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 7:14 PM Subject: Comma delimited files (CSV files) automatically inseted into database? > Is this possible? I tried it, and the format is all garbled... I have > an application that outputs data into a CSV file and was wondering of a > way to have it automatically inserted into a database with it formatted > for the query of those results. > > Thank you, > > Todd Williamsen, MCSE > home: 847.265.4692 > Cell: 847.867.9427 > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php