hmmm.. too simple! I will try it. Thanks. Kola Oyedeji wrote: > > > Richard > > You should be able to create linked tables in access containing all the > data then run a sql statement along the lines of. > > Create table myCopy as > ( > select ...from ... etc. > > ) > > HTH > Kola > > -----Original Message----- > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] > Sent: 23 September 2003 10:40 > To: CF-Talk > Subject: copying from one datasource to another > > I have 2 datasources, AccessLocal and WeirdRemote, this latter is some > sort of bespoke DB on a Unix box down a leased line somewhere the other > side of London, but I can get at it from CF via ODBC, and for that > matter from Access (on the server) via ODBC. > > What I want to do is copy various tables on WeirdRemote into > AccessLocal, basically to get a local copy of various tables on > WeirdRemote, but not all records (so there has to be a query of some > sort). > > Now I could do this by doing a query on WeirdRemote in CF and then > looping over it with a load of Inserts into AccessLocal, but this would > be rather complicated, and quite likely very slow. > > A better option seems to me to have a set of 'Make table queries' saved > in my AccessLocal datasource and then I simply 'run' them from CF and > the entire thing is then done in the background between WeirdRemote and > AccessLocal, and in fact this can be done manually in Access, but > because of WeirdRemote's licencing setup, only from the server. > > How to call the 'make table queries'? I don't seem to be able to do it > via CFQUERY but I expect this can be done via COM into AccessLocal... > anyone have an example code? > > > -- > Regards; > > Richard Meredith-Hardy > ------------------------------------------------------------- > [EMAIL PROTECTED] > Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
