Results 1 to 2 of 2

Thread: Exporting(importing) a text file in to Access

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2000
    Location
    Brunei
    Posts
    100

    Talking

    Hi everyone,

    I want to export a comma delimted text file in to an Access table. Is there any VB command to do this?

    Your help is greatly appreciated.

    Thank you.
    Rathi.j

  2. #2
    Fanatic Member
    Join Date
    Aug 2000
    Posts
    617

    ok...

    One thing we should never neglect before submitting a post is to do a search before.... in VB world... Here is what I found...doing so... I think Chris may have tackled this before


    Dim Myaccess As Access.Application
    Set Myaccess = CreateObject("Access.Application")
    With Myaccess
    .Visible = False
    .OpenCurrentDatabase "Cool.mdb"
    .DoCmd.TransferText acExportDelim, , lstExport, txtName
    .Quit
    End With

    Trouble is...it asks for the database password which I would rather hard code..any ideas where I can put it?
    __________________
    - Chris
    chris.kilhams@totalise.co.uk

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