Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Import dbf with VBA

Discussion in 'Information Technology' started by torreon, Nov 8, 2005.

Tags:
  1. torreon

    torreon
    Expand Collapse
    Guest

    Hi:
    I would like to import an Dbase IV table (dbf) in a mdb proyect with VBA.
    I have found code to import an access proyect table into another access
    proyect but this isn`t valid to me.
    Anybody knows how make it??

    thank you
     
  2. Loading...

    Similar Threads Forum Date
    Importance Of Dastar History of Sikhism Aug 12, 2016
    Importance Of Tirath / Pilgrimage As Per Gurbani Gurmat Vichaar Jun 1, 2016
    Superheroes: Arjan Bhullar Explains Wrestling's Importance In The Sikh Community Sports & Fitness Apr 15, 2016
    Important decisions in life Questions and Answers May 25, 2015
    Friendship Between Genders... Important Question Questions and Answers Dec 20, 2012

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You should be able to use the TransferDatabase method. Try "dBase
    IV;DATABASE=C:\dBASE\Samples" for the database type (pointing, of course, to
    the correct location!)

    If I recall correct, the dBase file must be a short file name (i.e. in 8.3
    format)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "torreon" <ikoroso@kaixo.com> wrote in message
    news:OCRlhY44FHA.3416@TK2MSFTNGP15.phx.gbl...
    >
    > Hi:
    > I would like to import an Dbase IV table (dbf) in a mdb proyect with VBA.
    > I have found code to import an access proyect table into another access
    > proyect but this isn`t valid to me.
    > Anybody knows how make it??
    >
    > thank you
    >
    >
    >
     
  4. torreon

    torreon
    Expand Collapse
    Guest

    I'm tried with
    DoCmd.TransferDatabase , "dBase IV", "C:\indicar.dbf", acTable

    and the program shows an error 3044.

    I have done manualy the import in access proyect an d it isn´t any problem.

    thank you

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> escribió en el
    mensaje news:%23Qe2xG54FHA.3192@TK2MSFTNGP12.phx.gbl...
    >
    > You should be able to use the TransferDatabase method. Try "dBase
    > IV;DATABASE=C:\dBASE\Samples" for the database type (pointing, of course,
    > to
    > the correct location!)
    >
    > If I recall correct, the dBase file must be a short file name (i.e. in 8.3
    > format)
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "torreon" <ikoroso@kaixo.com> wrote in message
    > news:OCRlhY44FHA.3416@TK2MSFTNGP15.phx.gbl...
    >>
    >> Hi:
    >> I would like to import an Dbase IV table (dbf) in a mdb proyect with VBA.
    >> I have found code to import an access proyect table into another access
    >> proyect but this isn`t valid to me.
    >> Anybody knows how make it??
    >>
    >> thank you
    >>
    >>
    >>

    >
    >
    >
     
  5. torreon

    torreon
    Expand Collapse
    Guest

    Sorry,
    I'd saw in internet and I have found the solution:

    DoCmd.TransferDatabase , "dBase IV", "c:\", acTable, "indicar.dbf",
    "indicar"

    thank you for your time




    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> escribió en el
    mensaje news:%23Qe2xG54FHA.3192@TK2MSFTNGP12.phx.gbl...
    >
    > You should be able to use the TransferDatabase method. Try "dBase
    > IV;DATABASE=C:\dBASE\Samples" for the database type (pointing, of course,
    > to
    > the correct location!)
    >
    > If I recall correct, the dBase file must be a short file name (i.e. in 8.3
    > format)
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "torreon" <ikoroso@kaixo.com> wrote in message
    > news:OCRlhY44FHA.3416@TK2MSFTNGP15.phx.gbl...
    >>
    >> Hi:
    >> I would like to import an Dbase IV table (dbf) in a mdb proyect with VBA.
    >> I have found code to import an access proyect table into another access
    >> proyect but this isn`t valid to me.
    >> Anybody knows how make it??
    >>
    >> thank you
    >>
    >>
    >>

    >
    >
    >
     

Share This Page