Import .DAT file into Access 2010?

[NMACH]

Could someone please shed light on improting a .DAT file into Access 2010?

Thanks in advance.

[June7]

What kind of data is in the dat file? Review http://pcsupport.about.com/od/fileex...f/dat-file.htm

[NMACH]

Here is a sample of one record

18:40,FDS2010,N,3,4,5

I have more than a million records like this. I tried converting the file extention to ".txt" and importing the text file into Access. It did work for few cases. However, for few files, it did not work and got this error "cannot open database". It may not be a database that your application reconizes or the file may be corrupt". I got the same error when I tried by changing the file extension to ".csv".

[June7]

That certainly looks like a CSV file. What is different about the files the import failed with?

If the file cannot be treated as a txt or csv then I don't think there is a way for Access to work directly with it.