jakebur01 Posted January 30, 2008 Share Posted January 30, 2008 Hello, I wrote a script in vb.net that has connected with mssql database and is writing all of the products in the table to a delimited text file. The table had some weird characters in it, so I have it delimited by "@", rather than comma or tab. I would like to use php to insert all of the @ delimited data into mysql database. Thanks, Jake Link to comment https://forums.phpfreaks.com/topic/88570-solved-inserting-delimited-file-into-mysql/ Share on other sites More sharing options...
effigy Posted January 30, 2008 Share Posted January 30, 2008 See LOAD DATA and its FIELDS TERMINATED BY option. Link to comment https://forums.phpfreaks.com/topic/88570-solved-inserting-delimited-file-into-mysql/#findComment-453424 Share on other sites More sharing options...
jakebur01 Posted January 30, 2008 Author Share Posted January 30, 2008 thank you. Link to comment https://forums.phpfreaks.com/topic/88570-solved-inserting-delimited-file-into-mysql/#findComment-453430 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.