Busy — Fri, 06 Sep 2002 23:38:54 +0000

congrats, and thanks for sharing the outcome

Peter J. Boettcher — Fri, 06 Sep 2002 20:05:01 +0000

Way to go Mike! Doesn't really matter how you beat a problem, as long as you beat it.

fifeclub — Fri, 06 Sep 2002 19:13:34 +0000

I just wanted to update everyone who tried to help me. I finally got my data into a mySQL table. I discovered the difference between my cvs output and a sample dump file was that the dump file had spaces following all the commas, while my cvs file did not. I just ran a find and replace all, for all commas to a comma with a space after it. I then saved it and changed the file extention from .cvs to .txt. It was a back-@ss way to do it but it worked!

Busy — Sun, 01 Sep 2002 00:15:09 +0000

the code Rob showed is included in a .php page

phpMyAdmin is real easy to use, but as a wise Mod here mentioned (Mairving) it's better to learn the web page method, using INSERT, UPDATE, ...
At first it all looks hard but do it a couple of times and its quite easy. then once you know the basics of written MYSQL then go back to phpMyAdmin
Kevin Yank has a few tutorials around the place, even on mysql.com itself

fifeclub — Sat, 31 Aug 2002 19:07:21 +0000

Sorry for my novice-ness. Your suggestion sounds promising but what do I do with it? (other than changing datafile.cvs to whatever I named it) Is this code to place in a php page? Or is this some command code to use within phpMyAdmin? And what's that coldata stuff?

Sorry but nearly all of my knowledge is in simple .shtml stuff. Maybe this project is a little beyond my current capabilities

ROB — Sat, 31 Aug 2002 13:28:06 +0000

why not drop the import as file idea, save the files as csv in excel, and do something like this:

<?php
$fp = fopen('datafile.csv', 'r');
while($coldata = fgetcsv($fp, 10000)) {
    $thequery = \"INSERT INTO mytable VALUES('$coldata[0]','$coldata[1]','$coldata[2]','$coldata[3]')\";
    mysql_query($thequery);
}
?>

Busy — Fri, 30 Aug 2002 22:50:32 +0000

my first time i had the rows but no content at all.

check your quotes and commas, are you missing any and lookout for things like: "Hi, I'm Bob" should be "Hi, I\'m Bob" .. very easy oversight to make.
Also were the contents in the text file correct with db tables?, if you declare notnull and upload/insert as null(empty) you'll get out of align. hope this hasnt confused you.

an example of what i use:
use dbname;

insert into dbname values
(null, "n is after m", "", "318", null),
....

etc etc, dbname being your database name, the first null is the auto increment number, n is after m is just some rubbish i put there but its the content, the one after is a blank field which coulc or could not contain data, but if i missed this out the next number would move over one and would be one short so throws the whole thing out of whack.
[note]Hope his make sense, still on first coffee of the morning[/note]

fifeclub — Fri, 30 Aug 2002 22:12:01 +0000

Hey, I made some progress! After I created a table within the database, I used the link "Insert data from a textfile into table" which did not give me errors. I said that it successfully entered 176 rows, which is the correct number of rows in my text file.

However when I then hit "browse" it shows me all of each row's column data showing up in the first field of the table

fifeclub — Fri, 30 Aug 2002 22:00:45 +0000

The info in the link looks good but I don't understand enough of the basics to know what it means. The problem is that I don't even know where to start I'm completely new to mySQL. I guess I should begin with what I was doing, then maybe somebody could shout out at me that I'm going about it all wrong.

I tried many formats, all of which say "You have an error in your SQL syntax near xxxx at line 1". I see in the phpMyAdmin that it says "Or Location of the textfile." so I've been concentrating on exporting the .xls file as a text file.

I created a database first and tried to "import" my data but it didn't work. So I figured that maybe I need to create a table first, so I created a table with 10 fields and tried to import using the same method ("Or Location of the textfile.") but that didn't help.

Peter J. Boettcher — Fri, 30 Aug 2002 19:19:06 +0000

What format did you save it as in Excel? Tab-delimited text?

You shouldn't have any problems importing that text file into mySQL. Maybe try bypassing phpMyAdmin, see this link for more info: http://www.mysql.com/doc/en/mysqlimport.html