I'd reckon your best bet would be to export a CSV file from the companies database and FTP or upload it up to your site, and import it from there. If they are using SQL Server there is some very good functionality to automate all this with DTS.
> -----Original Message----- > From: Eugene Gorman [SMTP:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 11:22 AM > To: CFAussie Mailing List > Subject: [cfaussie] RE: Updating web page database from the companies > data base > > No they are not in the same location. One will be on the companies office > server and the web page database is hosted somewhere else. > > I not sure what type of database the company uses but the web sites > database is done in access. > > Best Regards, > Eugene Gorman > http://www.velvetsystems.com > Ph 07 3369 6003 > > > At 11:09 AM 8/27/2003 +1000, you wrote: > >Are they both located in the same locations? > > > >If so, you might want to look at SQL replication between the two. > > > > > -----Original Message----- > > > From: Eugene Gorman [SMTP:[EMAIL PROTECTED] > > > Sent: Wednesday, August 27, 2003 11:08 AM > > > To: CFAussie Mailing List > > > Subject: [cfaussie] Updating web page database from the companies > > > database > > > > > > Hi all, > > > A customer of mine was to have their web page database being > constantly > > > updated from their company database to reflect the changes. What is > the > > > best was to go about this? > > > > > > Would I use XML or a csv file or something else? > > > > > > I has hoping someone could point me in the right direction. > > > > > > Best Regards, > > > Eugene Gorman > > > http://www.velvetsystems.com > > > Ph. 07 3369 6003 > > > > > > > > > --- > > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > > To unsubscribe send a blank email to > > > [EMAIL PROTECTED] > > > > > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > > > > > >------------------------------------------------------------------------- > ---------- > > > >The contents of this message are the views of the Author and do not > >necessarily reflect the views of SUNCORP METWAY LTD ABN 66 010 831 722. > > > >The content of this e-mail, including attachments is a confidential > >communication between the Suncorp Metway Group and the intended > addressee. > >Any unauthorised use of the contents is expressly prohibited. If you have > > >received this e-mail in error please contact the sender immediately and > >then delete the message and any attachment(s). > > > >http://www.suncorp.com.au > > > > > >--- > >You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > >To unsubscribe send a blank email to > [EMAIL PROTECTED] > > > >MX Downunder AsiaPac DevCon - http://mxdu.com/ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
