Access to SQL

I have some users that use an access database to (believe it or not) store
some data in.
I was wondering if there is a way to import this access file into SQL and
still be able to allow the users access to it to be able to enter in data?
Thanks."johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
You can import (or export) individual tables from Access into SQL Server.
In the most basic configuration you could link your SQL Server tables from
Access and allow users the ability to manipulate data. This solution would
not be that scalable. A code based solution would scale much better.
Steve|||The main reason why I was looking to move it over to SQL was because I am
not using SQL but have all the licenses for it. I only have a few for
Access and would rather use SQL than buy more licenses as they decide to add
more people.
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:OaCQ8JadEHA.3076@.TK2MSFTNGP10.phx.gbl...
> "johnfli" <john@.here.com> wrote in message
> news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
store[vbcol=seagreen]
and[vbcol=seagreen]
data?[vbcol=seagreen]
> You can import (or export) individual tables from Access into SQL Server.
> In the most basic configuration you could link your SQL Server tables from
> Access and allow users the ability to manipulate data. This solution would
> not be that scalable. A code based solution would scale much better.
> Steve
>|||You can use the Access Upsizing Wizard, which is free on MS web site
somewhere... It does not do the greatest job at picking data types and
lengths, nor does it bring across stored queries...
At better method would be to use DTS in SQL Enterprise Manager to port the
data over...
DTS is documented in Books On Line.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
> Thanks.
>