data import

[Guest]

hi

How to Create a Microsoft Access Macro to Import Information from a .Dat file.
if we have to create a specification , how to do it ?

~Abhi

 

[Guest]

Hi Abhi,

You didn't say what type of file your .DAT file represents. Is it a text
file? If so, is it a comma separate variable (csv) file, or a fixed-length
text file? You can create import specifications for text files. However, in
order to import a text file with the .DAT file extension, you will likely
need to use one of the methods outlined in this KB article, which includes
renaming the file or making a change to your registry:

ACC2000: Importing or Linking a Text File Fails for a File That
Does Not Have a Valid File Name Extension
http://support.microsoft.com/?id=304206

Note that while the KB article includes "ACC2000" in it's title, it likely
applies to Access 2002 and 2003 as well.

To create an import specification, follow these steps that I outlined in a
previous post here (message # 2):

http://groups.google.com/group/micr...thor:Wickerath&rnum=10&hl=en#be92d1387ccdf9b3


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________