Re: Select all tables from schema

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1079112069.398098_at_yasure...
| BloodHobbes wrote:
|
| >>Sounds like you are asking for an export to some of us. Is that what
| >>you are looking for?
| >
| >
| > What I want to do:
| >
| > Export all data to ACCESS with vb.net. For easy reporting in ACCESS i
| > want for some users to make an export to ACCESS when they want (their
| > reporting needs are to specific, so they can do it theirselves). But i
| > need to retrieve all the data in the database for the bulk export. I
| > was thinking of an select on each table but I thought maybe there is
| > an easier way. So that's why I posted this question to all those
| > specialists ;-).
| >
| > Thx for reading and helping!!!!!!!
| > Bloodhobbes
|
| Why? What can you do in Access that you can't do just leaving the
| data where it is? I mean other than adding a layer of complexity.
|
| --
| Daniel Morgan
| http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
| http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
| damorgan_at_x.washington.edu
| (replace 'x' with a 'u' to reply)
|

here's what we've done:

1. take the data with you
2. use the MS-access query and reports interface, which is a lot easier to use than oracle tools
3. merge with non-enterprise data

not really so crazy

;-{ mcs Received on Fri Mar 12 2004 - 11:31:17 CST