Sales Report - use as general Data Export Tool

[DogTags]

Hi All

 

Trying the Sales Report tool - very nice

 

Would like to make it a more general data export tool

 

For instance, would be great if it could export customer shipping address data to be used for an address label mailmerge.

 

Has anyone tried this? Is it possible?

 

Any other export tools around? So far, haven't found any.

 

Many thanks :)

Edited November 15, 2004 by DogTags

[Guest]

you can use mysql odbc to pull the info out of mysql and into whatever app you want to use, as long as it supports odbc

[DogTags]

you can use mysql odbc to pull the info out of mysql and into whatever app you want to use, as long as it supports odbc

<{POST_SNAPBACK}>

Thanks, John :)

 

I'm not sure how to apply mysql odbc directly, but might you know of any mysql tools, either win based or lin, that can do this?

 

Maybe there is a tool out there that can be aimed at the db to do the extractions.

 

Many thanks :)

[Guest]

it doesnt matter who's tool, they all will have to use mysql odbc if they want to talk with a mysql database from a windows application.

thus go to mysql.com and download the odbc connector, set it up and then you can open the database via excel. you may need to go to the help files for learning the proper way, as that is not a part of this forum, but there are plenty out there to teach you how to use odbc, if you dont want to use the help files.

[DogTags]

Thanks, John. This seems very interesting. Much appreciated :)