Is it possible??

solconsult

Hallo dear readers,

Is it possible to dump Microsoft Word File in to MySQL file?

My Database contains fields like : ID, Name, and Location. But my Microsoft Word File contains the above fields as follows:

ID
Name
Location

ID2
Name2
Location2

ID3
Name3
Location3

and so on.

Any comment will be appreciated
Solomon

crislewis

There are several ways to do this.

If you can write macros then write one to run through the list and create an sql file which takes the data and creates INSERT records. The use this file as a load into mysql.

If not then write a mail merge file which does the same thing.

You need to end up with a line for each record as follows:

INSERT INTO tablename (ID, Name,Location) VALUES (ID,Name,Location);
INSERT INTO tablename (ID, Name,Location) VALUES (ID2,Name2,Location2);

Remember to quote strings where necessary.

If you have Excel you could copy the data across into a column headed list and use the export function to create a csv file and load that in.

Bunkermaster

save as text file and parse it using PHP 🙂 (look at regular expressions)

Norman_Graham

A lot of what you can do in macros are just sophisticated search and replace routines. You can use the search and replace function in WORD and record your actions as a macro. If you look at the macro code once you've done a simple search and replace, you'll get the idea. The drop-down menus in search and replace reveal the code for things like paras (^p in the English version) and a whole bunch of other non-printable items. You can also use pattern matching to identify different elements. It's a very powerful tool once you know how.

Best of luck

Norman