Re: file conversion from SQL Server to Access

Allan:
Neither www.SQLDTS.com or www.SQLIS.com displays anything. I get a blank
screen. The www.konesans.com is a consultant. I need to do this myself. No
money to pay others to do the job. Have you got any other solutions ? Is
there a utility for Access like BCP in SQL Server ? I don't have a copy of
Access though so that could be a problem. Is there a Northwind database for
Access ? Two of the database tables are from the Northwind database.

Randy


"Allan Mitchell" wrote:

> You want to go the other way to most people
> <grin>(http://support.microsoft.com/default.aspx?scid=kb;en-us;Q237980)
>
> OK So there is no "Down sizing" tool i know.
>
> How much of the SQL Server functionality do you want to take with you?
>
> The two products are different animals and a one-one mapping of features is
> not there.
>
> DTS can be used to transfer the data and table structures ure but will no
> move relationships, constraints, stored procs etc etc.
>
>
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "rseedle" <rseedle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:021088D1-058C-4CAA-B579-54BDC8C6F8BB@xxxxxxxxxxxxxxxx
> > OK, how do I convert a SQL Server database file to an Access database file
> > ?
> >
> > Randy
>
>
>
.

Relevant Pages

  • Re: Granting consultant access to database
    ... then you should also check that the default database of his ... I need to grant a consultant access to one database on an sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Rights to run a DTS Package
    ... She is a datareader of the Database this pacakage hits. ... "Allan Mitchell" wrote: ... > The package owner is more or less a "Non problem". ... > bit) they are not authenticating to the SQL Server as a whole. ...
    (microsoft.public.sqlserver.dts)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
Loading