uploading large database

[horsetags]

Hi
Sorry if i should have posted in database but i am a newbie!
I have a text file, tab delimited with 40,000 names.

I have the admin page on my server for the database but everything i look at seems to show me how to import info 1 name at a time.
Obviously this is simple but so am i.

Is there a script that will reference my text file and put all the information into my database online?

Thanks

Paul

[leatherback]

You can probably do it directly through an SQL import statement (I do not know how!).

What I usually do: I load the file in a spreadsheet (I am running MS windows, so I use MS EXCEL), and do a merge with a word-processor, where I make a template for the inserts (In WORD (Through: tools > mail merge > create catalogue):

INSERT INTO content (PageId, SectionId, ParagId, Header, Content) VALUES ('«PageId»', '«SectionId»', '«ParagId»', '«Header»', '«content»');

The PageID, SectionID, ParagID, Header, content refer to colums in the spreadsheet.

After the dosument merg you have a huge list of SQL statements, which you can then copy>past>execute in your SQL statement window.

Hope this helps,

[horsetags]

Thanks
But i think i need to do a little bit more learning :-)

Paul

[leatherback]

Well, we all do, dont we? 😉

Have a look at www.mysql.com for more information on sql statements, and of course this website for PhP scripting.

J.

[horsetags]

Will do
Thanks