Rick & Christopher, There's also the option of converting the MS Access to a MS SQL backend and then use some Views to connect. That way you keep your Access front-end if needed and the AR Server can get to the data.
John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, January 09, 2007 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: Access DB to Remedy ** I remember converting some Access dbs to .csv files and importing them that way, though there was a good deal of data cleanup required prior to import. If you're on a SQL platform, there is a DTS connection option that might be better. Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Gillman Sent: Tuesday, January 09, 2007 10:36 AM To: arslist@ARSLIST.ORG Subject: Access DB to Remedy ** Listers, This has probably been covered at one point or another, but I'm wondering if there's an easy way to take an Access database and either 1) import it into Remedy 2) Use some sort of Plugin for Remedy 3) Perhaps an ODBC connection to it. The access DB is located physically on the same system as Remedy's DB. Just looking for ways to do this without having to re-create the whole thing in Remedy. Help is appreciated! :-) Thanks! v/r __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"