LB1234
asked on
import excel data into MySQL via PhpMyadmin
Hi Folks, I'm relatively new to PHP and MySQL but I do feel I know enough to be a teeny weenie bit dangerous. At any rate, I'm trying to be a hero for my company and create a web based solution to replace a rather clunky Access database everyone here is using. The access database revolves around importing large amounts of expense transactions we get from our credit card company in the form of an excel sheet. Many of the columns in the excel sheet are extraneous. The vendor who built the access database filters this information out, and I need to do something similar in MySQL. Should I manually remove the extraneous columns, convert the chart to CSV and import, or is there a way to do this programatically? Thanks!
ASKER
Ganga, the link wasn't relevant to my issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ray, sweet Mary in heaven that's way too advanced for me. Until I get better with PHP, I guess I'll have to just manually remove the columns I don't need. If you have any links handy for importing CSV files into phpmyadmin (manually) I'd be much obliged, Sir!
Please refer below mentioned link if it work.
http://vegdave.wordpress.com/2007/05/19/import-a-csv-file-to-mysql-via-phpmyadmin/
http://vegdave.wordpress.com/2007/05/19/import-a-csv-file-to-mysql-via-phpmyadmin/
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I ensure that the columns in the excel sheet will correspond to the right columns (and column names) in my MySQL database? Can I simply choose NOT to import some columns as opposed to deleting the extraneous columns?
ASKER
Thanks Ray. I only have to import once a month :)
http://stackoverflow.com/questions/16330242/how-to-import-excel-file-into-mysql-database-using-phpmyadmin