Converting a database to mySQL

fifeclub posted this at 19:38 — 2nd July 2002.

Joined: Feb 2001

My appology if this is somewhere on the forums but I searched and found nothing. I also appologize because I know nothing about what I'm about to ask.

I have an extensive database that is maintained in MS Word. Yes, I know the first question is why the heck did I do that. But anyway, I want to try to easily convert all this data into a mySQL file for use on my website. How can this be done?

I'll try to answer my own question as much as I can help. I can save the .doc file to a .html file, then import the .html file into MS Excell. (It's a start) From here I can either save as an .xls file or as a .dbf file (II ,III, or IV). In either case I still need to know if there's a way to convert the database to mySQL, so any help is appreciated (even if it's just to tell me that there's no way and I'm screwed).
:eek:

Thanks

Peter J. Boettcher posted this at 21:33 — 2nd July 2002.

They have: 812 posts

Joined: Feb 2000

I'm not a mySQL expert but once you have it in Excel format you should be able to export it as a text file. Once it is in a delimited text file format you should be able to import that into mySQL.

Check this link for more info: http://www.mysql.com/doc/m/y/mysqlimport.html

PJ | Are we there yet?
pjboettcher.com

mairving posted this at 00:54 — 3rd July 2002.

They have: 2,256 posts

Joined: Feb 2001

Yes, you will be able to import a text file into MySQL but you will have to build the table structure first.

fifeclub posted this at 01:47 — 3rd July 2002.

He has: 688 posts

Joined: Feb 2001

Quote: Originally posted by mairving
Yes, you will be able to import a text file into MySQL but you will have to build the table structure first.

Thanks. So like if I have say 8 "fields" per my 200 rows (200 people's info), I set that up first before importing? I have phpMyAdmin to work with. I looked around it for a bit but I'll have o read the documentation before I actually start this endevor. But it's good news that this is possible to do without entering all the data individually. Thanks again.