Quick import csv to mySQL ?

[vfaulkner]

I hope someone here can help, on a quick deadline...

I am new to mySQL as a database and I need to create table(s) to hold member data. The data is currently in several .csv formatted files.
Is there a quick to import the data for storage in mySQL? The searching/retrieving will come later.
When asking for number of fields, does that mean 26 headings like lastName or total, 26 headings times 1300 members/records?


I am using phpMyAdmin 2.11.9

Any other tips are welcome.

Thanks!

[DaveSawers]

Not sure what you're asking for here.

phpMyAdmin will directly import data from CSV files into MySQL. You can easily setup your CSV files in the necessary format for import by editing them in Excel or a text editor using a macro. To figure out exactly what the required format is, put in a couple of rows manually and export them to CSV.

Number of fields means number of columns in your table.

[vfaulkner]

When I tried to import, I received this error:
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name.ID, Name.EMAIL, Name.MEMBER_TYPE, Name.CATEGORY, Name.TITLE


so I need to change the heading/field names?? I think the files were taken from Crystal Reports, if that matters.

Also, since I have several files which could be different tables, could I save time editing with Access then importing?

[DaveSawers]

You need to change the CSV files so they are in the right format. What does a sample line in the CSV file look like?

[ronchalice]

Originally Posted by vfaulkner

When I tried to import, I received this error:
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name.ID, Name.EMAIL, Name.MEMBER_TYPE, Name.CATEGORY, Name.TITLE

The "NAME." identifies the table name that Crystal extracted from. Just do a global S&R to remove the "NAME." from the column heading. So you end up with column headings of EMAIL, MEMBER_TYPE, CATEGORY, ETC.

However, if you don't have a large number of tables to import, I'd recommend manually editing all of the column headers to get rid of all caps. Just make sure they're meaningful to you, and don't contain any spaces or unusual characters (e.g. try mbr_name, mbr_email, mbr_type, mbr_category, etc... a little time up front in getting the table right will save you a lot of time in the future.

[freezea]

Download myadmin and you can do it via your browser in a couple of sec's.
regards,
freezea~