Importinf Text data files in MS Access

devisrin4's Avatar, Join Date: Jan 2007
Light Poster

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
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Yeah, you can use the Microsoft Excel Driver to create a connection to the Excel file and insert it into the Access file.