Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    1

    Unanswered: exporting a csv file from excel to access using VB

    Hello,

    Hope someone ca help me, i am trying to export a .CVS file from excel to Access using VB, but haven't got a clue how to do it. Can someone give me some idea please if they have any.

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You mean import from Excel to Acce$$ then use

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, yourTableName, "C:\yourExcelFile2Import.xls", True

Posting Permissions

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