Link to home
Start Free TrialLog in
Avatar of LB1234
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!
Avatar of GangaramGavli
GangaramGavli

Avatar of LB1234

ASKER

Ganga, the link wasn't relevant to my issue.
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LB1234

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!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LB1234

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?
Avatar of LB1234

ASKER

Thanks Ray.  I only have to import once a month :)