You are here: Re: Quick question, need to pump CSV data into database « PHP SQL « IT news, forums, messages
Re: Quick question, need to pump CSV data into database

Posted by Dano on 09/23/06 12:24

Pretty easy to do with CSV and PHPMyAdmin.

If your file is in CSV, just go to the "Import" tab in PHPMyAdmin. It's
pretty standard across different PHPMyAdmin versions.

There, just browse for the file location, check the appropriate boxes,
and click "Go." Depending on your connection speed, it could take a
while. I used to load an 84-column, 12,000-row CSV file over a DSL
connection, and it would usually take 30-40 minutes, on average.

Hope that helps!

halbenca@gmail.com wrote:
> I have a CSV file with 5 columns and about 20000 lines. Is there a
> simple utility out there that will convert this file into a conforming
> text file I can then proceed to import into my database via Web
> interface phpMyAdmin? These are the confines I have to work within as
> I have to import it from the Web access of phpMyAdmin, any solutions or
> ideas? BEST REGARDS, Danny

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация