Morning, Would really appreciate any help on this subject.
I have a client who needs an offline access db to link up to an shared hosted online access db. They are trying to do an append query from the online to the offline DB and basically the query checks to see if the unique ID is there and if it is it won't overwrite it. I have only had a brief experience of CSV imports into Access so I don't know if this is possible. Any help would be appreciated Mike LIVE Developments Ltd __________________________ t: +44 (0) 871 2180223 f: +44 (0) 1794 511451 e: [EMAIL PROTECTED] w: www.livedevelopments.co.uk __________________________ -----Original Message----- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 30 September 2004 10:42 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Just a Quickie Is it possible / advisable to do this ? I have a database A which has datasource A and a database B which has a datasource B I want to read information from both tables in a common query. How do I combine the datasources? <cfquery name="readA" datasource=" (A&B)"> in that kind of fashion... Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
