Are there any easy way to access SQL tables behind BCM for dummies sunorain 4/18/2007 10:08:01 AM the point is there's no way to make easy mass editing or mass replacement of data in BCM. E.g. long time ago a database of companies was imported to BCM from MS Access database. Unfortunately many (if not all) URLs of web-sites containing in database became corrupted as result of importing data and what's worse - it has been noticed much later, after many amendments and modifications in database, so no chance to make import anew. Instead of http://www.company.com URLs look in BCM database like this: http://#http://www.company.com# It would be real pain to correct each entry one by one. May be I could access SQL table which is behing BCM (Outlook 2007, resp. SQL Express 2005) and do mass replacement of trash symbols in a specific column?

RE: Are there any easy way to access SQL tables behind BCM for dummies Samvnw51 4/18/2007 6:02:04 PM You can probabaly do this by accessing the appropriate table in the db and running a SQL update statement on it. However, it might be easier to export the BCM data to a csv file, make the edits and import it back in. Make sure you do a backup first of course. Good luck "sunorain" wrote: [Quoted Text] > the point is there's no way to make easy mass editing or mass replacement of > data in BCM. > E.g. long time ago a database of companies was imported to BCM from MS > Access database. > Unfortunately many (if not all) URLs of web-sites containing in database > became corrupted as result of importing data and what's worse - it has been > noticed much later, after many amendments and modifications in database, so > no chance to make import anew. > Instead of http://www.company.com > URLs look in BCM database like this: > http://#http://www.company.com# > > It would be real pain to correct each entry one by one. May be I could > access SQL table which is behing BCM (Outlook 2007, resp. SQL Express 2005) > and do mass replacement of trash symbols in a specific column?

Re: Are there any easy way to access SQL tables behind BCM for dummies John <duckdive[ at ]yahoo.com> 4/20/2007 2:06:32 AM I have an Access db with ODBC Linked Tables that allows me to view the information. I'm not sure if you can modify though. I'd like to know as well. John

Re: Are there any easy way to access SQL tables behind BCM for dummies Luther <enowning[ at ]gmail.com> 4/20/2007 6:27:27 PM On Apr 19, 7:06 pm, John <duckd...[ at ]yahoo.com> wrote: [Quoted Text] > I have an Access db with ODBC Linked Tables that allows me to view the > information. I'm not sure if you can modify though. I'd like to know > as well. > > John The docs say that database views that start with "Public" are intended to be updateable from outside BCM.

Re: Are there any easy way to access SQL tables behind BCM for dum sunorain 4/25/2007 4:34:00 PM Could you describe shortly please - how to connect Access with BCM SQL tables? All I could do is to click on "External data" tab and found there a set of incomprehensible dialogs asking for data sources. "John" wrote: [Quoted Text] > I have an Access db with ODBC Linked Tables that allows me to view the > information. I'm not sure if you can modify though. I'd like to know > as well.

Re: Are there any easy way to access SQL tables behind BCM for dum John <duckdive[ at ]yahoo.com> 5/9/2007 10:43:34 PM You will need to create an ODBC SQL Server connection to the SQL instance with the BCM data. This is done very much the same way that you would connect to any other database. Essentially, you go to Control Panel, Administrative Tools, Data Sources (ODBC), then create a new System DSN using SQL Server as the driver. John