Results 1 to 7 of 7

Thread: importing a dbf in a access database...

  1. #1

    Thread Starter
    Member Red Thread's Avatar
    Join Date
    Aug 2000
    Location
    Europe-Belgium
    Posts
    44
    hello,

    My question is the following ;

    How can i import (as fast as possible) a dbase (dbf) database in access (mdb)database.


    If it's possible, give a small example in code...

    - Any fool can know, the point is to understand -

  2. #2
    Lively Member
    Join Date
    Oct 2000
    Location
    Chicago
    Posts
    97

    Importing dbf into access

    You can import a dbase database into Access by following the steps:

    1. Open Access database from Start>Programs>Microsoft Access
    2. Select Blank Database option and click OK.
    3. It will prompt with a dialog box for "File New database".Create a database by giving some name Ex: database1 and click "Create" Button.
    4. Then you will see Access database with Tables,Queries,Forms,Reports,Macros & Modules.Click the "New" button and you will see a dialog box with Dtasheet view,Design view,Table,import and link.
    5. Click on the import table and then click ok.
    6. You will see a Import dialog box.In that click the "Files of Type" combo box and select dBASE III and then select the filename of your dBASE III database.
    7.That's it... It will import the dBASE III database into Access database.And you can start viewing your database..

    Hope this is clear to you.

    Regards
    Anil

  3. #3

    Thread Starter
    Member Red Thread's Avatar
    Join Date
    Aug 2000
    Location
    Europe-Belgium
    Posts
    44

    Talking thx ! But....

    Well, jeeze...thanks for your reply ! But... how can i bring this to you....

    I need this in VB code.

    Anyway, thx

  4. #4
    Guest
    I'm positive there's a better way to do it, BUT

    In code:

    1. Open the database
    2. Attach the dbf file
    3. write a sql query to create a new table.

    Like I said, there's got to be a better way, but this will
    work. If the file were from another engine where you could
    write a pass-thru query, you could do the same without
    attaching the file.

    Good Luck, and hope this helps
    DerFarm

  5. #5

    Thread Starter
    Member Red Thread's Avatar
    Join Date
    Aug 2000
    Location
    Europe-Belgium
    Posts
    44

    Lightbulb A ha

    Do you have a little example in code for point 3?
    I can go as for point 2.

    With sql you mean "insert into..." ??

  6. #6
    Guest
    "Select * from tablename into NewTableName"



    No secret about it, it is simply a make table query. Once
    you have attached a table to an Access database, as far as
    Access is concerned, it is a native table.

    You can also read data from Access Databases that are NOT
    connected. I have an example, but its in the other
    machine, and the e-mail isn't working. Essentially, you

    Select blah-blah from blah-blah IN FILENAME

    Once you specify IN FILENAME, you are essentially writing a
    pass-thru.

    Good Luck
    DerFarm

  7. #7

    Thread Starter
    Member Red Thread's Avatar
    Join Date
    Aug 2000
    Location
    Europe-Belgium
    Posts
    44

    Talking thx

    thx derfarm,

    i'm sure gonna try.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width