Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: import fixed-width file using transfaretext error with .dat file


Message #1 by "abed edammat" <edammat@y...> on Wed, 29 Aug 2001 09:58:00
hi all



i developed  application using access97 ,,there is a pice of program to import dat 

file  in access97 it's fine 

but when i convert it to access200 it allways alert me that "object or data base 

read only " i check  database and file it  r/w per.  



when i convert the extention of the file to .txt  it is work fine also but i still 

need to import text file with .dat extention   



"

OLD_FILE_NAME = [FILE_NAME] + ".DAT"

TABLE_NAME = "CORRECT_TEMP"

DoCmd.TransferText acImportFixed, "YY", TABLE_NAME, PATH_NAME + OLD_FILE_NAME

"



thank you 

abed


  Return to Index