RE: Import text file with non-standard file ext.
From: Richard (richard_at_discussions.microsoft.com)
Date: 01/01/05
- Previous message: Dave_at_LAD: "RE: Import text file with non-standard file ext."
- In reply to: Dave_at_LAD: "RE: Import text file with non-standard file ext."
- Next in thread: Dave_at_LAD: "RE: Import text file with non-standard file ext."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 31 Dec 2004 18:19:01 -0800
Thank you, Dave
You just made my day.
Richard
"Dave@LAD" wrote:
> Hi Richard
>
> Have you looked at KB article 306144 ACC2000: How to Import a Text File That
> Has an Extension That Access Does Not Recognize?
> Here's the link:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;306144
>
> I also found the scripting article Much ADO About Text Files
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting03092004.asp)
> helpful because I needed to import a custom file format.
>
> Happy New Year!
>
> Dave
> DaveAtLADEnterprizesDotCom
>
> "Richard" wrote:
>
> > The TransferText method will not import into Access a text file with a
> > non-standard file extension (i.e., custom ext for a separate application).
> > If the extension is manually changed to .txt, the file is able to be
> > imported. I want the user to only have to select a file for programmatic
> > processing and not to have to intervene manually.
> >
> > Can an additional file extension be added to the list of acceptable text
> > file extensions used by TransferText? Or is there some other means to
> > accomplish the import programmatically?
- Previous message: Dave_at_LAD: "RE: Import text file with non-standard file ext."
- In reply to: Dave_at_LAD: "RE: Import text file with non-standard file ext."
- Next in thread: Dave_at_LAD: "RE: Import text file with non-standard file ext."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|