Rick and L.J. Thanks for the help. It's not a critical thing, more of a "it'd be nice to do." but I think I'll try later tonight to convert it to a SQL DB, and then using a view form. My only question would be. if I needed to convert data back to access, could I just export in .csv format and then import it?
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, January 09, 2007 12:52 PM To: arslist@ARSLIST.ORG Subject: Re: Access DB to Remedy Or, you can use SQL DTS (Data Transformation Service) to convert the file into a SQL DB, (there's already an Access connector), from which you could access the existing data via a View form. You could also import it into an existing DB table, but I'd be VERY careful about doing so into an existing Remedy form. If you create a new form in Remedy with the proper fields, and then import the data, as L.J. said, that will keep Remedy's metatables much happier. As usual, there are multiple ways to skin this cat, and you have to decide which one works best for you. Rick _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Tuesday, January 09, 2007 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: Access DB to Remedy ** Are you looking to just get the Data into Remedy? If so you will need to create the tables in remedy manually...and then you can export from Access into CSV and then simply import the data _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Gillman Sent: Tuesday, January 09, 2007 11: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___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"