"rmcompute" <rmcompute@discussions.microsoft.com> wrote in message
news:E46CB866-6C4B-4CA8-BF20-4BBA08445E54@microsoft.com...
> 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.

"Jack Vamvas" wrote:

> 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@discussions.microsoft.com> wrote in message
> news:E46CB866-6C4B-4CA8-BF20-4BBA08445E54@microsoft.com...
> > 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.
>
>