Results 1 to 5 of 5
  1. #1
    Join Date
    May 2005
    Posts
    12

    Unanswered: Trying To Import DBase File into Access2007

    I have like 100 files i need to import into Access 2007 from DBase. I can't figure out how to import more than one file at a time. It takes a LONG TIME!

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Forums FAQ

    What kind of files? How do you want to import them? From where? What format are they in? Is there a pattern to their names? Where are they going? All into one table or separate tables, or something else entirely?

    Quote Originally Posted by Teddy's FAQ
    In short, give us half a chance at actually being able to answer your question. Make it as easy as possible, and you're FAR more likely to get a response.
    Me.Geek = True

  3. #3
    Join Date
    May 2005
    Posts
    12
    They are DBF files within a folder. I'm trying to import them all into one Access table. Some of them have patterns to their names but overall no. The patterns appear in sections.

    Thanks!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    One at a time it is then.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    You are going to have to write some code to do that. Do you know VBA (Visual Basic for Applications)? If you do then you will need to do 100 docmd.TransferDatabase statements. You can get a list of all the DBFs by using the FileSystemObject.

    If you know VBA and the above doesn't help that much I can provide some code. Otherwise it might be a manual process.

Tags for this Thread

Posting Permissions

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