1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Importinf Text data files in MS Access

Discussion in 'MS Access' started by devisrin4, Jan 24, 2007.

  1. devisrin4

    devisrin4 New Member

    Joined:
    Jan 23, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    hi

    i am importing the text format data files to MSAccess 2003 by using import option. but the problem is text data will change daily so i have to update the files daily. can we do this programatically.

    Solution without useing DSN is prefered one if we don't hvae other option then i will go with that

    Thank you
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Yeah, you can use the Microsoft Excel Driver to create a connection to the Excel file and insert it into the Access file.
     

Share This Page