Re: DDF Files to SQL

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 16:52:16 -0000

If you can find an ODBC driver or OLE DB provider for your PeachTree DDFs,
then you can use DTS to load those files into SQL Server. 

-- 
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"Chris Chandler" <see@top.com> wrote in message
news:Xns9596727A4D0C1nospmnet@207.46.248.16...
Is there a way to import data form Peachtree DDF files into SQL server
directly or does the information need to be parsed or filtered thru
something
like Crystal Reports to have the information exported to a Database?

Relevant Pages

  • Re: Job status on Mainfram
    ... Mainframe load place a record somewhere that DTS can check. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Loading a .bak file with C#?
    ... To load a .bak file you would RESTORE the file to SQL Server. ... To do that you do not need DTS at all. ...
    (microsoft.public.sqlserver.dts)
  • Re: Update or Insert
    ... I would load the data into a temp table. ... Hopefully you have a primary key ... > I want to load data from a data csv file into a sql server table. ... > Will DTS take care of this automatically? ...
    (microsoft.public.sqlserver.dts)
  • Re: Filtering source data during DTS run
    ... cleaner and faster to load text files into a working table and then use TSQL ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • RE: Whats the best way
    ... server and load it with dts. ... change the dts process to read the Access db directly. ... > we need this data in an SQL Server DB. ... > Then I figure I take over and use DTS to import the data into the SQL Server ...
    (microsoft.public.sqlserver.dts)