Can Msde import DBF files in my tables

Hi Sergio,
This took me a while to figure out, but it is really simple. From my
message a few weeks ago...
"Just to update people (and for my future reference when I search Google
for my name), using DTS makes it VERY simple to import DBF files into SQL.
What screwed me up was two things:
1) While it may be possible to do in MSDE, it is very simple using DTS
on the server. I logged into my client's SQL server and ran DTS, filled
out a few options and imported all the FoxPro info into a new SQL database.
2) DTS is actually found via: Start Program > Microsoft SQL Server >
Import Export Data ... this launches the DTS wizard. I was looking
specifically for something called DTS. I should have tried the
import/export option first"
Hope this helps
Richard
Sergio wrote:

> Hi, y really now if its possible in MSDE,
> can i import DBF files in my tables of MSDE?, how?, i need import in Tsql,
> how?
> thanks
Yes, it's easy in DTS but you can also save a DTS package that can then be
run in the MSDE.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Richard Fagen" <no_spam@.my_isp.com> wrote in message
news:uX2K49CHEHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi Sergio,
> This took me a while to figure out, but it is really simple. From my
> message a few weeks ago...
> "Just to update people (and for my future reference when I search Google
> for my name), using DTS makes it VERY simple to import DBF files into SQL.
> What screwed me up was two things:
> 1) While it may be possible to do in MSDE, it is very simple using DTS
> on the server. I logged into my client's SQL server and ran DTS, filled
> out a few options and imported all the FoxPro info into a new SQL
database.
> 2) DTS is actually found via: Start Program > Microsoft SQL Server >
> Import Export Data ... this launches the DTS wizard. I was looking
> specifically for something called DTS. I should have tried the
> import/export option first"
>
> Hope this helps
> Richard
> Sergio wrote:
Tsql,