Results 1 to 2 of 2

Thread: Import to Access

  1. Nov 11th, 2009, 02:33 PM #1
    RosieP
    RosieP is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2009
    Posts
    273

    Import to Access

    I have a text file with many fields. I need to import one of the fields into an existing table in access. This process needs to be done daily.
    what would be the best way to do this?
    Thank you.
    Reply With Quote Reply With Quote
  2. Nov 12th, 2009, 12:09 AM #2
    leinad31
    leinad31 is offline
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: Import to Access

    Create a small app to be run via windows task scheduler. App will implement code in link http://www.vbforums.com/showthread.p...ght=csv+select. I suggest you simply rename file (append timestamp to extension) in order to keep track which files have already been uploaded (upload only those with .txt extension). Fixed locations (mdb and text files) would facilitate processing (no need to read configuration file).
    Roman Numerals, Number In Words,Indian Currency Format, Modified Insertion Sort, Fibonacci
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width