Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Importinf Text data files in MS Access (http://www.go4expert.com/forums/importinf-text-data-files-ms-access-t2680/)

devisrin4 24Jan2007 09:14

Importinf Text data files in MS Access
 
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

pradeep 24Jan2007 14:02

Re: Importinf Text data files in MS Access
 
Yeah, you can use the Microsoft Excel Driver to create a connection to the Excel file and insert it into the Access file.


All times are GMT +5.5. The time now is 14:44.