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 Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.