We are all used to seeing the 'rows and columns' metaphor when looking at data. In fact it is the primary interface for many of our data analysis tasks.

But rows and columns can hide valuable patterns. What happens when you take data out of a database and visualize it as a network? Now you can see important connections, centrality, trends, movement over time, and many other key indicators.

Check out our article on Link Analysis and Social Network Analysis to see how our Sentinel Visualizer solution provides innovative ways to get more meaning from your data.

In Access 2003 or earlier, you may have seen truncated numbers on forms or reports, and not realized that you weren’t seeing the full value. Access 2007 includes a new option tocheck for truncated number fields and display pound signs (#) to indicate that the entire value is not shown.

While attempting to import an Access 2007 format database (*.ACCDB), you may receive an error such as: Unrecognized Database Format or Could not find installable ISAM. These errors can occur if you do not have the appropriate driver installed to import data from ACCDB files.

Importing Microsoft Access MDB databases into SQL Server is a built in feature of SQL Server. However, because of the difference between the database engine of Microsoft Access 2007 and earlier versions of Microsoft Access, it is not possible to connect to the Access 2007 database using the built-in data source “Microsoft Access”. You can use this if you wish toimport data from a MDB format, but not an ACCDB from Access 2007.

Microsoft SQL Server 2005 offers the Import and Export Wizard to move data from one source to a destination. With the Import and Export wizard, you can access different types of data sources. These sources include other database formats such asMicrosoft Access, Microsoft SQL Server, flat files, Microsoft Excel or Oracle database.