Hi all,

I'm here becauze i have a big problem that i cannot solve any other way!.

First i'll explain the sollution i'm looking for. A friend of mine has a great MySQL databaes wich contains over 3500 items and growing every day with 50 items or more. For every item he needs specific data for in an XLS sheet. I've tried to make with PHP a script to convert the data to an existing XLS sheet. But it didn't work out fine due the reason not all webhosters allow using COM objects... so now i need to find another sollution for importing data to excel.

So i thought about other things and got to search them. I read about Excel that it could import XML data into existing sheets. That's just what i need; but i don't know how importing works... i'm just not a prof in excel!.

So what do i need? well first i tell you about the MySQL data wich i'll convert to XML.

The MySQL database contains orders, alot of orders. (order example)

- Username
- Userid

- Dealername
- Dealerid

- Order date

- Product type
- Pruduct comments

Now i can convert this data to XML, that's easy but how to import this into EXCEL? i have no idea how to do that!

Could anyone tell me more about importing XML data into excel. If anyone gives me a correct answer or can help me create a document wich can... i'll have a little financial present (if allowed on this board)

(sorry for my bad english, my dutch is 90% better )