Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: how to import .dat file


Message #1 by "abed edammat" <edammat@y...> on Thu, 6 Sep 2001 07:42:32
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





Message #2 by Brian Skelton <brian.skelton@b...> on Thu, 6 Sep 2001 13:27:58 +0100
You need to look at article Q245407 in the microsoft knowledgebase, which 

can be searched for here: http://search.support.microsoft.com/kb/





-----Original Message-----

From:	abed edammat [SMTP:edammat@y...]

Sent:	06 September 2001 08:43

To:	Access

Subject:	[access] how to import .dat  file



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