Re: MSDE newbie quetsion: importing data from SQL Server

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

From: Simon Elliott (Simon)
Date: 05/27/04 

Date: Thu, 27 May 2004 07:57:54 -0700

On 26/05/2004, Andrea Montanari wrote:
> > I've been given a file with no extension, and told that it's "a full
> > export from our SQL server tables".
> >
> > What sort of file is this likely to be, and is there any way I can
> > import it into MSDE?
>
> it really depend what kind of file it is...
> it can be a full backup of a database, and you can test it executing
> from any query tool
> RESTORE HEADERONLY
> FROM DISK = 'c:\.....\filename'

This returned something sensible. How do I import it into MSDE? 

-- 
Simon Elliott    http://www.ctsn.co.uk

Relevant Pages

  • Re: MSDE newbie quetsion: importing data from SQL Server
    ... On 27/05/2004, Andrea Montanari wrote: ... but I think MSDE from the Office 2000 suit is MSDE ... Simon Elliott http://www.ctsn.co.uk ...
    (microsoft.public.sqlserver.msde)
  • Maintenance required after deploying merge pull replication?
    ... I won't have direct administrative access to their copy ... I could write an application to interface with MSDE through ... the ActiveX controls... ... What sort of control am I going to need so that I can always be sure ...
    (microsoft.public.sqlserver.replication)
  • Re: Re-ordering of Tables
    ... Microsoft Access ships with MSDE. ... This index DOES sort the rows in the table in the order of the ... the thing Damon is asking about. ... it- cause data corruption? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need of MSDE on W2003SBS Server?
    ... Greg Low ... MSDE Manager SQL Tools ... > Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
  • Re: Need basic technical MSDE information.
    ... MSDE Manager SQL Tools ... "Andrea Montanari" wrote in message ... > Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)