Are there any easy way to access SQL tables behind BCM for dummies

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
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
Click to expand...

The docs say that database views that start with "Public" are intended
to be updateable from outside BCM.
 
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.
 
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
 
Back
Top