Avatar of PeggyPitchford
PeggyPitchford
 asked on

Transferring CSV files to MYSQL

Hello Experts,

I have to populate a MYSQL database with CSV files.  The database exists, but I have no idea what it looks like or what tables are in the database or anything.  Actually, I have no idea what the hell to do.  I have many problems with this and I am looking for guidance.  I need to get a listing of the tables in the database, with the field names.  I need to know how to import CSV files into the database tables.  And then, to top it off, I need to test it to see if the data is where it is supposed to be.  I would love to pitch a fit about this software company, but that won't get the job done, so, any ideas?

Thanks in advance.

Peggy

MySQL Server

Avatar of undefined
Last Comment
leakim971

8/22/2022 - Mon
leakim971

did you open the file with any text editor? for example the notepad
PeggyPitchford

ASKER
leakim971,

The CSVs open in Excel.  In terms of the database, I have not tried to open the database yet as I am not sure what to do.  I can see the data in the CSVs just fine, with the column headings, keys, etc.  Hope that answers your question.

Peggy
leakim971

check this link : http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/

take in midn a csv file is first a text file, not an excel file format

you can open with the notepad to see what you have inside
Your help has saved me hundreds of hours of internet surfing.
fblack61
leakim971

try something like : http://jsfiddle.net/acWsv/
PeggyPitchford

ASKER
leakim971,

Thanks for the tech-recipes.  I was able to populate my table, but I had to match the field names in the csv file to the field names in the mysql table. Is there an easy way to map fields to a my sql table without having to do that cleanup first?  And, should I open another question for this topic and consider this question answered?

Peggy
ASKER CERTIFIED SOLUTION
leakim971

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
PeggyPitchford

ASKER
leakim971,

Thanks so much for the toad-for-mysql.  Now I can see why things are not working!  Wow, what a great tool.  I appreciate all your help and will let you know how it turns out.

Peggy
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
PeggyPitchford

ASKER
Fabulous!  Thanks for much for the help!
leakim971

;-)) enjoy!!!