Linking .DAT files

[RGarcia87]

How do I link .DAT files into a table? I am using Access 2003. There is no option to link this file type.

 

[Bastien]

.DAT is usually a text file...

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[JonFer]

You need to update your registry settings. Look up this topic at Microsoft's Knowledge Base - there is an article on it.

 

[BNPMike]

If it is a text file, rename it to .txt.

 

[RGarcia87]

I can't rename to .txt, it is too big.

 

[JonFer]

You can rename it in Window's Explorer regardless of the size - just right-click on the filename. Don't try to open it to rename it.

Updating the registry allows you to treat any file extension as text without renaming. In your case where it sounds like it's a one-time process, just rename it.

 

[RGarcia87]

I don't want to have to rename it. It's a .dat file in a cd and I would like to be able to link to it. I would like to automate this as much as possible. Why is it that I can bring it in Excel and not Access?

 

[p27br]

jonfer

can you post the link to that article you mention, I am also interested

thanks

 

[JonFer]

http://support.microsoft.com/default.aspx?scid=kb;en-us;306144

 

[p27br]

thanks