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

    Unanswered: appending multiple files to a table

    What's the best way to routinely grab data from csv files with different names in a directory folder and append those rows to an Access table? The csv's have the identical field names to the Access table.

    Thanks!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    That's a little open-ended. TransferText and TransferSpreadsheet are common ways of importing data. To do it on a schedule, I'd probably create an MDB that performed your imports when it started, then quit. Then I'd call that MDB from Scheduled Tasks as appropriate.
    Paul

Posting Permissions

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