Re: A97: Can't import a text file to an Access 97 table?
- From: MLH <CRCI@xxxxxxxxxxxxxx>
- Date: Sun, 24 Jul 2005 18:41:27 -0400
David, I appreciate the input. Thx much. But I disagree
wholeheartedly.
Can you explain to me why clicking Start, Run and typing
C:\DOCUME~1\Owner\LOCALS~1\Temp\WER2E70.tmp.dir00\appcompat.txt
then pressing Enter invokes NotePad and finds the file perfectly well.
That's certainly not the syntax you were talking about and you'll find
no quotation marks in there. According to your comments, that can't
be done. Can you explain why pointing MS Access to it while attempting
to import the txt file fails? I don't think so.
If you are correct, and I am ignorant of NT's CMD syntax, how about
explaining why I can launch CMD, type
cd\docume~1\owner\locals~1\temp
press Enter and reach the desired directory w/ no problem? So much
for the LFN syntax, huh? The fact is, David, the above syntax works
perfectly well in the CMD window. And I'm afraid you're wrong about
MS not hiding the file. Fact is, they have. They did so by hiding the
directory in which the file is located.
You should actually try what I outlined in my original post. Go ahead
and try it first. Ask me, and I'll tell you how to force MS Access to
create the text file. That way, you can replicate the text file for
yourself. Then repost your comments. I'd love to hear what you have to
say afterwards.
.
- Follow-Ups:
- Re: A97: Can't import a text file to an Access 97 table?
- From: David W. Fenton
- Re: A97: Can't import a text file to an Access 97 table?
- References:
- A97: Can't import a text file to an Access 97 table?
- From: MLH
- Re: A97: Can't import a text file to an Access 97 table?
- From: MLH
- Re: A97: Can't import a text file to an Access 97 table?
- From: David W. Fenton
- A97: Can't import a text file to an Access 97 table?
- Prev by Date: Re: I could use some help with a query using mulitplication
- Next by Date: Re: I could use some help with a query using mulitplication
- Previous by thread: Re: A97: Can't import a text file to an Access 97 table?
- Next by thread: Re: A97: Can't import a text file to an Access 97 table?
- Index(es):
Relevant Pages
|