|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Export SQL Server to Access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Export SQL Server to Access
|
|
| nbaxley 2002-10-05, 9:07 pm |
| I have a client that wants to take the data they have in SQL Server
and make it accessible in Access. They don't want to have a link
connection to live data, but basically download the SQL server
database on to their desktop and walk away from a connection with it.
Their preferred format is MS Access, but other options might be worth
it.
Has anyone done this or have any ideas on how to approach it?
Nate Baxley
| |
| Dejan Sarka 2002-10-05, 9:07 pm |
| Hi!
I guess the Data Transformation Services (DTS) is the tool that you need. Do
please read about it in SQL Books OnLine.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"nbaxley" <groups@baxleys.org> wrote in message
news:5a593f76.0209112029.365e680b@posting.google.com...
> I have a client that wants to take the data they have in SQL Server
> and make it accessible in Access. They don't want to have a link
> connection to live data, but basically download the SQL server
> database on to their desktop and walk away from a connection with it.
> Their preferred format is MS Access, but other options might be worth
> it.
>
> Has anyone done this or have any ideas on how to approach it?
>
> Nate Baxley
|
|
|
|
|