Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Access Rss

   Items 1 to 20 of 35    Older >>
 

Simple step by step process to import MS Access data into SQL Server using SSIS

Sometimes we need to import information from MS Access. We could use the Microsoft SQL Server Migration Assistant, but sometimes we need to add custom transformations and it is necessary to use more sophisticated tools. In this tip, we are going to walk through step by step how to migrate a MS Access table to SQL Server using SQL Server Integration Services (SSIS).  Read more...
Rating:  Rate this |   Briefcase | 3,672 reads

Migrating Microsoft Access Databases to SQL Server 2008

Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.  Read more...
By Additional Articles 2011/07/26 | Source: Database Journal | Category: access
Rating: (not yet rated)  Rate this |   Briefcase | 2,862 reads

Are all rounds created equal

By Timothy Bates 2010/10/13 | Category: round
Rating: (not yet rated) |  Discuss |   Briefcase | 2,960 reads

Microsoft Access: Business Intelligence on a Shoestring

Learn how to deliver dynamic content by building a meaningful Business Intelligence Application, utilizing only what is available on the client's desktop, when a Data Warehouse BI Application, SQL Server and SSIS/SSRS aren't an option.   Read more...
By Additional Articles 2010/04/16 | Source: Database Journal | Category: access
Rating: (not yet rated)  Rate this |   Briefcase | 3,347 reads

Converting Access Queries with iff() and DLookup() to SQL Server

This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.  Read more...
By Fred Simmons 2010/03/08 | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 7,646 reads

Access

By VM-723206 2009/06/25 | Category: access
Rating: (not yet rated) |  Discuss |   Briefcase | 4,364 reads

Using the OPENROWSET function in SQL Server

OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.  Read more...
By Additional Articles 2009/05/05 | Source: SearchSQLServer | Category: openrowset
Rating: (not yet rated)  Rate this |   Briefcase | 3,582 reads

How To Read A PayPal Notification Email

Learn how to read information from a PayPal Notification email by using Microsoft Access, Outlook and VBA.  Read more...
By Additional Articles 2009/04/17 | Source: Database Journal | Category: paypal
Rating: (not yet rated)  Rate this |   Briefcase | 2,768 reads

Find and Generate Missing Values in an Access Table

Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. Find it here.   Read more...
By Additional Articles 2009/01/23 | Source: DevX | Category: access
Rating: (not yet rated)  Rate this |   Briefcase | 1,629 reads

Use Access 2007 to Get Started in Data Mining

Learn how you can use Microsoft Access 2007 as a basic data mining tool for exploring your valuable data. This article illustrates how data filters, pivot graphs, queries in graphs and filters in reports can help this cause.  Read more...
By Additional Articles 2009/01/16 | Source: Database Journal | Category: access
Rating: (not yet rated)  Rate this |   Briefcase | 2,511 reads

MS Access Can Handle Millisecond Time Values--Really

MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.  Read more...
By Additional Articles 2008/10/03 | Source: DevX | Category: access
Rating: (not yet rated)  Rate this |   Briefcase | 2,060 reads

Modifying Microsoft Access Linked Tables from SQL Server

In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access. As is the case with all systems, how does Access manage the changes? What happens when you modify the structure of the underlying SQL Server table? What happens to the SQL Server table if you delete the linked table in Access? We will look at each of these situations in this tip.  Read more...
By Additional Articles 2008/05/14 | Source: MSSQLTips.com | Category: access
Rating:  Rate this |   Briefcase | 3,378 reads

Linking Access to SQL Server

For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.   Read more...
By Andy Warren 2007/11/02 (first published: 2006/01/25) | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 26,831 reads

Browser Style Form Navigation

This article series features a demo app affectionately named Something Not Entirely Unlike Access, which employs a variety of methods to obfuscate the "Accessian" features.   Read more...
By Additional Articles 2007/09/06 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 3,256 reads

Access to SQL Server: The Upsizing Wizard

SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.   Read more...
By Kathi Kellenberger 2007/01/12 (first published: 2005/02/22) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 30,085 reads

Access to SQL Server: Linking Tables

SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to   Read more...
By Kathi Kellenberger 2006/11/17 (first published: 2005/02/23) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 42,411 reads

Save and Retrieve Datasheet Layout with the Windows Registry

Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.  Read more...
By Additional Articles 2006/09/01 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 1,834 reads

Linking Access to SQL Server

For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.   Read more...
By Andy Warren 2007/11/02 (first published: 2006/01/25) | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 26,831 reads

Digging Into Access Performance

Access can be a very quick and easy to use tool for working with SQL Server data and for quick and dirty projects, it might be the best tool. But there can be performance issues at times and Andy Warren digs into some of these based on some analysis of what Access does behind the scenes.   Read more...
By Andy Warren 2006/01/02 | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 8,074 reads

Consume Web Service from Access

A few months ago, I posted an article here at DBJ named How to Pass Access Data Across the Web. One reader expressed concern over using the Microsoft Internet Explorer library because of security issues. While I do not share his fear, I appreciate that others might, so I began to think about how the process could be enhanced by substituting a Web Service for the traditional ASP/Querystring web page approach described in the article. What follows is the fruit of those labors.  Read more...
By Additional Articles 2005/12/21 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 2,384 reads
   Items 1 to 20 of 35    Older >>
 
Tags
programming (20)    
sql server 7 (4)    
upgrading (4)    
miscellaneous (2)    
business intelligence (1)    
data mining (1)    
data types (1)    
dlookup (1)    
iif (1)    
integration services (ssis) (1)    
openrowset (1)    
paypal (1)    
product reviews (1)    
reviews (1)    
round (1)    
sql server 2005 (1)    
sql server 2008 (1)    
t-sql (1)    
union (1)    
union all (1)