https://www.webmaster-forums.net/crss/node/1018804 en https://www.webmaster-forums.net/web-database-development/converting-database-mysql#comment-1110992 <blockquote class="bb-quote-body"><p>Quote: <em>Originally posted by mairving </em><br /> <strong>Yes, you will be able to import a text file into MySQL but you will have to build the table structure first. </strong></p></blockquote> <p>Thanks. So like if I have say 8 "fields" per my 200 rows (200 people's info), I set that up first before importing? I have phpMyAdmin to work with. I looked around it for a bit but I'll have o read the documentation before I actually start this endevor. But it's good news that this is possible to do without entering all the data individually. Thanks again.</p> <p><img src="https://www.webmaster-forums.net/misc/smileys/smile.png" title="Smiling" alt="Smiling" class="smiley-content" /></p> Wed, 03 Jul 2002 01:47:37 +0000 fifeclub comment 1110992 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/converting-database-mysql#comment-1110990 <p>Yes, you will be able to import a text file into MySQL but you will have to build the table structure first.</p> Wed, 03 Jul 2002 00:54:10 +0000 mairving comment 1110990 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/converting-database-mysql#comment-1110988 <p>I'm not a mySQL expert but once you have it in Excel format you should be able to export it as a text file. Once it is in a delimited text file format you should be able to import that into mySQL.</p> <p>Check this link for more info: <a href="http://www.mysql.com/doc/m/y/mysqlimport.html" class="bb-url">http://www.mysql.com/doc/m/y/mysqlimport.html</a></p> Tue, 02 Jul 2002 21:33:28 +0000 Peter J. Boettcher comment 1110988 at https://www.webmaster-forums.net