Thread: SQL to DBF....

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    5
    Rep Power
    0

    SQL to DBF....


    I am in need of any help pertaining to the conversion of a SQL table to a DBF database in ASP.NET...


    Anybody...?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    You are wanting to export a relation database table to a DBF flat file? What DBMS are you using?
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    5
    Rep Power
    0
    In my Sourcecode I'm using OleDBConnection to connect to an ODBC data source....

    I'm not a pro when it comes to DB's, but as far as I understand the fact that the table I want to export is in a relational database shouldn't have an effect because the specific table that i want to export does not have any relations with any other tables...
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    As long as the table does not have Foreign keys that are defined in another table your data will be consistent.
    ...
    If you are using the oleDB have you explored using Visual Basic to read from the table and write to the target file?
    ...
    If you have access to the Microsoft DTS you can also you its engine to do this as well.
    ...
    For the money, data junction has been real solid as well.
    ...
    Let me know if you have any questions.
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html

IMN logo majestic logo threadwatch logo seochat tools logo