Re: can MSDE import DBF files?

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

From: Euan Garden[MS] (euang_at_online.microsoft.com)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 15:19:02 -0800

If you are doing serious development with MSDE then I suggest buying
Developer Edition which includes all the tools, for $50 to help you.

You could create a DTS package to solve the problem, then save it to VB and
embed the functionality in your app. MSDE includes the DTS runtime but not
the GUI so it will execute just fine. 

-- 
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Fagen" <no_spam@my_isp.com> wrote in message
news:#1jOrPqDEHA.684@tk2msftngp13.phx.gbl...
> Hi Andrea,
>
> Thanks for your advice.  I just download the SQL books on line.  Wow,
> that is an amazing resource.  It will keep me busy for a long time :)
>
> I just want to clarify a few points...
>
>  From your reply, it seems there are two different technigues.
> 1) use the DTS designer to import DBF files into SQL format
> or
> 2) Add a linked server
>
> I'm guessing the linked server keeps the data in DBF format but SQL can
> read it?  While I have worked with DBF's for 20 yrs now, it is time for
> me to move my clients to the more robust and scalable SQL format.  While
> I will try both techniques, I think it is best to move them over to
> native SQL format.
>
> When you mentioned "SQL Server client tools like Enterprise Manager" do
> you mean MSDE's oSQL tool used from the desktop?  Or Enterprise Manager
> on the server?
>
> Can I use your great tool, DbaMGR2k, to import DBF files?
>
> Thanks again for your help
>
> Richard Fagen
>
> Andrea Montanari wrote:
> >>Hi Everyone,
> >>
> >>I'm wondering if there is an easy way to import FoxPro datafiles
> >>(DBF/FPT) into SQL format?
> >>
> >>I suspect it might be simpler to use the server's Admin console to
> >>import the DBF then backup the database and restore it in MSDE
> >
> >
> > if you have the SQL Server client tools like Enterprise Manager, you can
use
> > the DTS designer to import all your data from dbase/fox tables into SQL
> > Server/MSDE tables...
> > else, you can add a linked server to your instance using the JET OLE-DB
> > provider to manage those kind of data...
> > suppose you have on drive d:\ a file named d:\Turismo.dbf
> > it consist of a unique table [dbf =;-)) ]
> > open oSql.exe and execute
> >
> > EXEC sp_addlinkedserver  dbf ,'Jet 4.0'
> >      , 'Microsoft.Jet.OLEDB.4.0'
> >    , 'D:\'
> >    , NULL
> >    , 'dBASE III'
> > GO
> >
> > a linked server pointing to d:\ will be set and all dbf files there
present
> > will be treated as tables...
> > ie:
> >
> > SELECT TOP 10 * FROM dbf...TURISMO
> > -- INSERT INTO dbo.TableName SELECT <select list> FROM FROM
dbf...TURISMO
> > WHERE <filter condition>
> > GO
> >
> > you have to reference the tables using the 4 part naming convention
> > servername.databasename.owner.table which, in this case, only supports
> > servername and table name becouse of the nature of the particular
datasource
> >
> > when finished, remove the linked server executing
> > EXEC sp_dropserver @server =  'dbf'  ,  @droplogins = 'droplogins'
> > GO
> >
> > I'd like to invite you to download the SQL Server Books On Line, the
> > definitive on line help for SQL Server you can find at
> > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp , where
you
> > can find quite all human possible about SQL Server... =;-))
> > hth
Quantcast