Transfer data from Internet to local database

[RC63]

I use a database on the internet from wich I retrieve Orders placed. I want to
save the retrieved information to my local disk, and from there import them
into another database that is run locally. I run an SQL query that retrieves
the information, no problems there. But how can I save It to local disk in a
format that can be imported into MS-Access database Can anyone Help!

[Paul Whitham TMM]

There are three options

1) FTP the database down and work from that
2) There are some extensions around that enable you to convert the query
into a .csv file which can be imported into excel, or
3) The simplest of all, in IE simply highlight the output from your query,
select copy, then in excel selected paste.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"RC63" <webforumsuser@macromedia.com> wrote in message
news:d0mj15$kpo$1@forums.macromedia.com...

> I use a database on the internet from wich I retrieve Orders placed. I

want to

> save the retrieved information to my local disk, and from there import

them

> into another database that is run locally. I run an SQL query that

retrieves

> the information, no problems there. But how can I save It to local disk in

a

> format that can be imported into MS-Access database Can anyone Help!
>