Results 1 to 3 of 3

Thread: Sending data to a Access database

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Ireland
    Posts
    224

    Question

    I have a few thousand files that are all in the same format. I need to know how to connect to a database to send all the information within these files (*.txt) up to my database. I have set up the database with all the relavent fields and have set up the parsing of the text file. Can someone please tell me how to send that data up to the database.

    Thanks a lot
    JK

  2. #2
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    Use the Dir function to retrieve the filenames in a given directory and then parse them individually. Presumably you know about Open, Input, Get etc.?

    If not, post back and I'll drop some code off.

    P.
    Not nearly so tired now...

    Haven't been around much so be gentle...

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Ireland
    Posts
    224
    Thanks a lot fot the reply. I would really appreciate a little bit of code as an example to work off. I'm a little bit rusty on the VB at the moment!!!!!!

    Thanks again
    JK

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