DTS is available as one of the tools when you install SQL. If you have Enterprise Manager, you probably have DTS, too. It allows you to (among other things) import data sources that are not SQL into SQL as DB tables, using connectors that come with the utility. Access has one already configured for it. Once you started playing with it, I bet that you'd have a SQL copy of your Access db in a day or less. Rick _____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Tuesday, January 09, 2007 12:20 PM To: [email protected] Subject: Re: Access DB to Remedy ** Rick, Is the DTS anything like using the Upsizing wizard in Access? You can keep your old data but I think the Local table will not get updated once the Upsizing is completed. Your application gets connected to the remote (to ms access) db. Or does DTS give you a view into the MSC Access db file? 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 2:24 PM To: [email protected] Subject: Re: Access DB to Remedy ** Well, I would suggest that you leave your original table alone, and just make a copy of it in SQL, which is what the DTS tool does. Then play with the copy. I'm not sure what import options exist for Access, but I would imagine that .csv or .xml would be among them. Rick _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Gillman Sent: Tuesday, January 09, 2007 11:20 AM To: [email protected] Subject: Re: Access DB to Remedy ** 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: [email protected] 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: [email protected] 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: [email protected] 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___ __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"
