Re: Upgrading from Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

1)How regualarly would you extract the data?
2)It is fairly straight forward to access data for SQL Server from Access-
you can use the IMPORT function , and wrap it in a DTS.
Be careful, as there are datatypes in Access , that do not necessariliy
automatically convert to SQL server data types
3)For documentation- just do a google search on using: SQL server import
access


Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm

"rmcompute" <rmcompute@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E46CB866-6C4B-4CA8-BF20-4BBA08445E54@xxxxxxxxxxxxxxxx
I work for a company which uses local Access databases at 15 different
locations through-out the country. If I want to extract data from these
databases, I have to import the tables from the respective servers or
create
linked tables to those servers. The data connection is not instantaneous
and
in some cases takes a few minutes to pull even a small amount of data.
Could
each of these databases be set up to update tables on an SQL Server for
which
I could connect to and wouldn't this speed up data acccess speed ? Is
there
any documentation on the web which describes how to set this up ? I am
assuming that the local database speed would slow down if they accessed an
SQL table as opposed to the local Jet table.


.

Relevant Pages

  • Re: Install of SQL Server 2005 fails due to no space to extract pa
    ... Actually I am using sqleval.exe (180 day trial of the SQL server 2005). ... It went through the extracting package stage, ... location to extract to. ... tried to install that. ...
    (microsoft.public.sqlserver.setup)
  • Re: Load Excel to SQL Server using .NET
    ... The first step is to allow the users to upload the file using the File HTML ... datasource to extract the data. ... > be inserted into various SQL Server tables for reporting/query ... > One sample application we have uses an ActiveX control that is called via ...
    (microsoft.public.dotnet.framework.aspnet)
  • SSIS - OleDB source as table view Hideously Slow ??
    ... In migrating data into Sql Server from flat file sources I've found SSIS to ... now I need to extract some complex data out of Sql Server ... ... when I try to load this view into SSIS using an OldDb Data Source ...
    (microsoft.public.sqlserver.dts)
  • Re: filter from the datasource
    ... You need an OLEDB connection to SQL Server. ... You need an OLEDB Source Adapter ... In your SQL Statement you say ... I need to extract all employees with state='CA' from a sqlServer 2005. ...
    (microsoft.public.sqlserver.dts)
  • Re: filter from the datasource
    ... You need an OLEDB connection to SQL Server. ... You need an OLEDB Source Adapter ... In your SQL Statement you say ... I need to extract all employees with state='CA' from a sqlServer 2005. ...
    (microsoft.public.sqlserver.dts)