Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    London,UK
    Posts
    54

    Unanswered: csv upload to access from a form

    i need my vba front end of access to allow a user to point to a csv file and allow them to upload this data to a table. can this be done and can any1 give me an idea of where to start.

    thankx in advance

  2. #2
    Join Date
    Nov 2003
    Location
    LONDON
    Posts
    238

    Re: csv upload to access from a form

    Originally posted by tinkxtheminx
    i need my vba front end of access to allow a user to point to a csv file and allow them to upload this data to a table. can this be done and can any1 give me an idea of where to start.

    thankx in advance
    You can use DoCmd.TransferText acImportDelim, "Standard Output", _
    "External Report", "C:\Txtfiles\April.doc" for example to import a text file. You could use ADO as well. Both these methods will import the data in bulk. If you wanted to verify the data as it is imported you could use the Windows Scripting object to go through each line in a text file and import it into a table.

Posting Permissions

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