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,

Can I link to tables in an instance of MSDE from Access 2003?

I have a small program that linked to ACT! version 6 dbf files. I now have
ACT!7 SQL version. This uses MSDE. I need to link to the ACT! tables in the
MSDE instance. Any hints? ACT! technical help says I can not link. I
thought I would ask the real MSDE experts instead.
hi Scott,
Scott wrote:
> I have a small program that linked to ACT! version 6 dbf files. I
> now have ACT!7 SQL version. This uses MSDE. I need to link to the
> ACT! tables in the MSDE instance. Any hints? ACT! technical help
> says I can not link. I thought I would ask the real MSDE experts
> instead.
what do you mean by "link"?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Access/JET supports linked tables as does SQL Server itself. This is mostly
a matter of setting up the links from within Access. I have not done this in
years so I can't help with the current versions, but I don't see a reason
why it can't be done unless the ACT! database rights have been tuned to
prevent this.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:D75B4CED-FF49-4CFC-BAB6-DE4538CBF476@.microsoft.com...
>I have a small program that linked to ACT! version 6 dbf files. I now have
> ACT!7 SQL version. This uses MSDE. I need to link to the ACT! tables in
> the
> MSDE instance. Any hints? ACT! technical help says I can not link. I
> thought I would ask the real MSDE experts instead.